On this tab you can set special rules for generating default names of database objects to be applied in various cases of the Model First approach usage. When setting these rules, you can use predefined keywords which will be replaced with the corresponding values.
Primary Key Column
Defines special naming rules for primary key columns. Predefined keywords, which will be replaced with corresponding values are: %entity name%, %property name%.
%entity name%
Name of the entity, containing the simple type property, the column is generated for.
%property name%
Name of the entity key property, the column is generated for.
Foreign Key Column
Defines special naming rules for foreign key columns. Predefined keywords, which will be replaced with corresponding values are: %entity name%, %master entity name%, %master property name%.
%entity name%
Name of the dependent entity.
%master entity name%
Name of the master entity, the foreign key refers to.
%master property name%
Name of the entity key property of the master entity, the foreign refers to.
Complex Type Property Columns
Defines special naming rules for generating column names that correspond to complex type's properties. Predefined keywords, which will be replaced with corresponding values are: %property name%, %parent property prefix%, %parent property name%, %complex type name%.
%property name%
Name of the simple type property, belonging to the complex type.
%parent property name%
Name of the complex type property, containing the simple type property, the column is generated for.
%complex type name%
Name of the complex type.
%parent property prefix%
If the parent property name contains the complex type name, then this keyword returns the fragment of the parent property name that precedes the complex type name occurrence in the parent property name. Otherwise, an empty string is substituted for this keyword.
Primary Key Column for TPT Inheritance
Defines special naming rules for discriminator columns for TPT inheritances. Predefined keywords, which will be replaced with corresponding values are: %entity name%, %base entity name%, %base property name%.
%entity name%
Name of the entity, containing the simple type property, the column is generated for.
%base entity name%
Name of the base entity of the TPT hierarchy.
%base property name%
Name of the entity key of the base entity of the TPT hierarchy.
Discriminator Column for TPH Inheritance
Defines special naming rules for discriminator columns for TPH inheritances. Predefined keywords, which will be replaced with corresponding values are: %base entity name%.
%base entity name%
Name of the base entity of the TPT hierarchy.
How Special Rules Work
Example 1Suppose, that the default value of the Primary Key Column special rule is changed to %property name%ID. This means, that if we add a new entity key to a class, and call it, for example, Employee, the corresponding automatically generated name of the table column will be EmployeeID. Example 2Suppose, we have a model containing the Address complex type with the City and PostalCode properties, and the Employee class with a set of properties including the ShipAddress complex type property. As the Complex Type Property Columns special rule is set to %parent property prefix% %property name%, the names for database columns corresponding to the Address complex type properties are automatically generated equal to ShipCity and ShipPostalCode, since Ship is actually a prefix. Thus, the Employees table contains a set of columns including ShipCity and ShipPostalCode.
|