Employee

Inheritance hierarchy

Hierarchy type None
Is abstract False

Relationships

The Employee entity is part of the following relationships

Related Entity Full description
Customer Customer.Employees - Employee.Customers (m:n) (via TestGroup.Order)
Employee Employee.Manager - Employee.ManagedEmployees (m:1)
EmployeeTerritories EmployeeTerritories.Employees - Employee.EmployeeTerritories (m:1)
Region Employee.Region_ - Region.Employee (m:1)
Region Region.Employee_ - Employee.Region__ (m:n) (via Employee)
Shipper Shipper.Employees - Employee.Shippers (m:n) (via TestGroup.Order)
Territory Employee.Territories - Territory.Employees (m:n) (via EmployeeTerritories)
TestGroup.Order TestGroup.Order.Employees - Employee.Orders (m:1)

Fields

The following fields are defined in the Employee entity

Name Type Is PK Is FK Optional Read-only Max. length Precision Scale
Address AddressVt 0 0 0
BirthDate datetime (System.DateTime) Yes 0 0 0
EmployeeId int (System.Int32) Yes Yes 0 0 0
Extension string (System.String) Yes 4 0 0
FirstName string (System.String) 10 0 0
HireDate datetime (System.DateTime) Yes 0 0 0
HomePhone string (System.String) Yes 24 0 0
LastName string (System.String) 20 0 0
Notes string (System.String) Yes 1073741823 0 0
Photo byte[] (System.Byte[]) Yes 2147483647 0 0
PhotoPath string (System.String) Yes 255 0 0
PostalCode string (System.String) Yes 10 0 0
RegionId int (System.Int32) Yes Yes 0 0 0
ReportsTo int (System.Int32) Yes Yes 0 0 0
Title string (System.String) Yes 30 0 0
TitleOfCourtesy string (System.String) Yes 25 0 0

Unique Constraints

None.

None.

Mappings

Northwind.dbo.Employees (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
Address.Address Address Yes nvarchar 60 0 0
Address.City City Yes nvarchar 15 0 0
Address.Country Country Yes nvarchar 15 0 0
Address.Region Region Yes nvarchar 15 0 0
BirthDate BirthDate Yes datetime 0 0 0
EmployeeId EmployeeID int 0 10 0 SCOPE_IDENTITY()
Extension Extension Yes nvarchar 4 0 0
FirstName FirstName nvarchar 10 0 0
HireDate HireDate Yes datetime 0 0 0
HomePhone HomePhone Yes nvarchar 24 0 0
LastName LastName nvarchar 20 0 0
Notes Notes Yes ntext 1073741823 0 0
Photo Photo Yes image 2147483647 0 0
PhotoPath PhotoPath Yes nvarchar 255 0 0
PostalCode PostalCode Yes nvarchar 10 0 0
RegionId RegionID Yes int 0 10 0
ReportsTo ReportsTo Yes int 0 10 0
Title Title Yes nvarchar 30 0 0
TitleOfCourtesy TitleOfCourtesy Yes nvarchar 25 0 0

Code generation information

Setting values

Employee (Entity)

Setting name Value
Entity base class name CommonEntityBase

Address (NormalField)

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

BirthDate (NormalField)

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

EmployeeId (NormalField)

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

Extension (NormalField)

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

FirstName (NormalField)

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

HireDate (NormalField)

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

HomePhone (NormalField)

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

LastName (NormalField)

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

Notes (NormalField)

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

Photo (NormalField)

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

PhotoPath (NormalField)

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

PostalCode (NormalField)

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

RegionId (NormalField)

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

ReportsTo (NormalField)

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

Title (NormalField)

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

TitleOfCourtesy (NormalField)

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

Customers (NavigatorCollection)

Setting name Value
Navigator property is public True

EmployeeTerritories (NavigatorCollection)

Setting name Value
Navigator property is public True

ManagedEmployees (NavigatorCollection)

Setting name Value
Navigator property is public True

Manager (NavigatorSingleValue)

Setting name Value
Navigator property is public True

Orders (NavigatorCollection)

Setting name Value
Navigator property is public True

Region_ (NavigatorSingleValue)

Setting name Value
Navigator property is public True

Region__ (NavigatorCollection)

Setting name Value
Navigator property is public True

Shippers (NavigatorCollection)

Setting name Value
Navigator property is public True

Territories (NavigatorCollection)

Setting name Value
Navigator property is public True

Attribute definitions per element

Extension (NormalField)

  • StringLength

FirstName (NormalField)

  • StringLength

HomePhone (NormalField)

  • StringLength

LastName (NormalField)

  • StringLength

Notes (NormalField)

  • StringLength

PhotoPath (NormalField)

  • StringLength

PostalCode (NormalField)

  • StringLength

Title (NormalField)

  • StringLength

TitleOfCourtesy (NormalField)

  • StringLength

Manager (NavigatorSingleValue)

  • Browsable($true)

Region_ (NavigatorSingleValue)

  • Browsable($true)

Additional interface definitions per element

None.

Additional namespace definitions per element

None.