DbMapping Properties

The properties section is where you can configure, for your dbMapping, all mappings between entity properties and the database table columns.

It is necessary when the table column name is different from the entity property name.

Fields

A property contain the following fields to be defined:

PropertyName

The name of the entity property linked to the current dbMapping.

Requirements Rules:

• Is Required;
• The name must exist in Entity Properties list in the current model;
  • See Entity Property section for more details.

Example:

Properties:
- PropertyName: Entity01_Property01

---

ColumnName

The name of data table column in your database that refers to the current entity property.

Requirements Rules:

• Must start with a letter;
• Must contains only letters, numbers and the underline char ('_');
• Max length of 128 chars

Example:

Properties:
- PropertyName: Entity01_Property01
  ColumnName: Table01_Column01

---

Comment

It allows configuring a comment to be applied to the table column at the time of it's creation.

Requirements Rules:

• Max length of 500 chars

Example:

Properties:
- PropertyName: Entity01_Property01
  ColumnName: Table01_Column01
  Comment: Store the order number

---