Shipper

Inheritance hierarchy

Hierarchy type	None
Is abstract	False

Relationships

The Shipper entity is part of the following relationships

Related Entity	Full description
Customer	Customer.Shippers - Shipper.Customers (m:n) (via TestGroup.Order)
Employee	Shipper.Employees - Employee.Shippers (m:n) (via TestGroup.Order)
TestGroup.Order	TestGroup.Order.Shippers - Shipper.Orders (m:1)

Fields

The following fields are defined in the Shipper entity

Name	Type	Is PK	Is FK	Optional	Read-only	Max. length	Precision	Scale
CompanyName	string (System.String)					40	0	0
Phone	string (System.String)			Yes		24	0	0
ShipperId	int (System.Int32)	Yes			Yes	0	0	0

Unique Constraints

None.

Fields mapped onto related fields

None.

Mappings

Northwind.dbo.Shippers (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
CompanyName	CompanyName		nvarchar	40	0	0
Phone	Phone	Yes	nvarchar	24	0	0
ShipperId	ShipperID		int	0	10	0	SCOPE_IDENTITY()

Code generation information

Setting values

Shipper (Entity)

Setting name	Value
Entity base class name	CommonEntityBase

CompanyName (NormalField)

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

Phone (NormalField)

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

ShipperId (NormalField)

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

Customers (NavigatorCollection)

Setting name	Value
Navigator property is public	True

Employees (NavigatorCollection)

Setting name	Value
Navigator property is public	True

Orders (NavigatorCollection)

Setting name	Value
Navigator property is public	True

Attribute definitions per element

CompanyName (NormalField)

• StringLength

Phone (NormalField)

• StringLength

Additional interface definitions per element

None.

Additional namespace definitions per element

None.