Database Provider - Here you select the type of database; Sql Server, MySQL, SQLite, Oracle. Auto Create Database - When this is checked, a blank database will be created once you successfully exit the form. Database Check - This allows you ...
The Schema Dictionary represents all the tables and columns within a Stencil or Project Workspace. Table Name - This identifies the table name. In this case - Invoice Primary Key - This symbol indicates that this is the primary key column Foreign K ...
Context Menu When you right-click on the Schema Dictionary, you will see this menu: Add - This allows you to add a new column to your Schema Dictionary. Please have a look here for details. Change - This allows you to change/update the currently se ...
This explains what the icons and identifiers in the Schema Dictionary represent. View - Table - Primary Key - Foreign Key - Self Referencing Column (SRC) - SRC Not Supported - The column name will show an overstrike when ...
This allows you to Add Tables and Add/Edit Columns manually in the Database Schema.
This allows you to add multiple columns to a particular table, without having to manually click the Add button. This comes in handy when you have more than one column to add.
This allows you to update or make changes to a particular column. Name – The property name of the column. Examples include FirstName, LastName, or any property defined in your model or class. Caption – A human-readable title for th ...
This allows you to delete a column from its table.
The Advanced Configuration interface allows you to update Tables and columns at the same time. Table name - This is the name of the currently selected table. Table - Tables Droplist - Enabled - Table Grid - Updates - ...
Some stencils use strings computed from other related tables ( i.e. foreign key tables). For example, in the Chinook database, the Customer table is a foreign key table to the invoice table:So, we may want to display Customer.FirstName +", " + Custom ...
...
...
The Schema Import Wizard uses the Entity Framework Scaffolder to import your schema into CodeStencil.
This allows you to select Tables/Views that you want code generated for. Select/Deselect Tables - This allows you to select or deselect the tables in a batch. Tables - These are the tables in your schema dictionary. Related Tables - These are the t ...
Actions - This Drop button allows you to perform database related actions on the Schema Dictionary. For more detailed explanation on these functions see: Schema Dictionary - Actions View Schema Diagram - Checkbox -& ...
A Data Transfer Object (DTO) is a simple design pattern for transporting necessary data between different parts of an application. This could be between the client and server. The primary role of a DTO is to act as a data container. It&n ...
You can update the Table Label directly within this grid. To learn how to set up a Tabel Label, click here. When this option is checked, only tables without Table Labels are displayed; when unchecked, every table is displayedWhen it is unchecked ...
A Table Label is a column that represents how rows from a foreign key (lookup) table are displayed. When a table is used as a lookup in another table, the Table Label column is the one shown to users instead of just displaying the raw foreign key value. ...
The way foreign keys are stored in your Schema Dictionary after a database import or AI code generation directly impacts the application's code. Missing foreign key references, for example, will result in generated code that is incomplete or incorrect, le ...
You can import a SQLScript into the Schema Dictionary. You can access this functionality from: Schema | Schema Importer | Import From a SQL Script
This is an alternative (or additional) name for a column when it appears in the list of columns in a DTO (Data Transfer Object). The Mapped Name field allows you to map the Artist.Name navigation property from the Album entity to the ArtistName stri ...
Clicking the Update Search Column button, the system helps you manage which columns in your database tables are marked as searchable. By default, the dialog will only show tables with no searchable columns. This helps you quickly identify which tabl ...
These gives you the option of ... Table/View Properties -
In an ORM like Entity Framework (EF), a self-referencing table is one where a column acts as a foreign key pointing to the primary key of the same table. This design allows the table to establish relationships within its own data, enabling the representat ...