Department

Inheritance hierarchy

Hierarchy type Target per entity hierarchy
Is abstract False

Department (Hierarchy root)

Discriminator field: DepartmentType

Entity Discriminator value
Department G
Board B
Marketing M

Relationships

The Department entity is part of the following relationships

Related Entity Full description
Employee Employee.WorksForDepartment - Department.Employees (m:1)
Manager Manager.ManagesDepartment - Department.Managers (m:1)

Fields

The following fields are defined in the Department entity

Name Type Is PK Is FK Optional Read-only Max. length Precision Scale
DepartmentId int (System.Int32) Yes Yes 0 0 0
DepartmentType string (System.String) Yes 10 0 0
Name string (System.String) 50 0 0

Unique Constraints

None.

None.

Mappings

InheritanceOne.dbo.Department (SQL Server (SqlClient))

Aspect Value
Type of target Table
Actions allowed Create / Retrieve / Update / Delete
Entity Field Target field Nullable Type Length Precision Scale Sequence Type converter
DepartmentId DepartmentID int 0 10 0 SCOPE_IDENTITY()
DepartmentType DepartmentType varchar 10 0 0
Name Name varchar 50 0 0
Unmapped fields in target
Target field Nullable Type Length Precision Scale
MeetingRoomCode Yes varchar 10 0 0

Code generation information

Setting values

Department (Entity)

Setting name Value
Entity base class name CommonEntityBase

DepartmentId (NormalField)

Setting name Value
Generate as nullable type True
Field property is public True

DepartmentType (NormalField)

Setting name Value
Generate as nullable type True
Field property is public True

Name (NormalField)

Setting name Value
Generate as nullable type True
Field property is public True

Employees (NavigatorCollection)

Setting name Value
Navigator property is public True

Managers (NavigatorCollection)

Setting name Value
Navigator property is public True

Attribute definitions per element

None.

Additional interface definitions per element

None.

Additional namespace definitions per element

None.