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.

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.