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.

Fields mapped onto related fields

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.