TestGroup.Order

Inheritance hierarchy

Hierarchy type	None
Is abstract	False

Relationships

The TestGroup.Order entity is part of the following relationships

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

Fields

The following fields are defined in the TestGroup.Order entity

Name	Type	Is PK	Is FK	Optional	Read-only	Max. length	Precision	Scale
CustomerId	string (System.String)		Yes	Yes		5	0	0
EmployeeId	int (System.Int32)		Yes	Yes		0	0	0
Freight	decimal (System.Decimal)			Yes		0	19	4
OrderDate	datetime (System.DateTime)			Yes		0	0	0
OrderId	int (System.Int32)	Yes			Yes	0	0	0
RequiredDate	datetime (System.DateTime)			Yes		0	0	0
ShipAddress	string (System.String)			Yes		60	0	0
ShipCity	string (System.String)			Yes		15	0	0
ShipCountry	string (System.String)			Yes		15	0	0
ShipName	string (System.String)			Yes		40	0	0
ShippedDate	datetime (System.DateTime)			Yes		0	0	0
ShipPostalCode	string (System.String)			Yes		10	0	0
ShipRegion	string (System.String)			Yes		15	0	0
ShipVia	int (System.Int32)		Yes	Yes		0	0	0

Unique Constraints

None.

Fields mapped onto related fields

Name	Field type	Mapped onto field	Read-only
CompanyName	string (System.String)	Customer.CompanyName

Mappings

Northwind.dbo.Orders (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
CustomerId	CustomerID	Yes	nchar	5	0	0
EmployeeId	EmployeeID	Yes	int	0	10	0
Freight	Freight	Yes	money	0	19	4
OrderDate	OrderDate	Yes	datetime	0	0	0
OrderId	OrderID		int	0	10	0	SCOPE_IDENTITY()
RequiredDate	RequiredDate	Yes	datetime	0	0	0
ShipAddress	ShipAddress	Yes	nvarchar	60	0	0
ShipCity	ShipCity	Yes	nvarchar	15	0	0
ShipCountry	ShipCountry	Yes	nvarchar	15	0	0
ShipName	ShipName	Yes	nvarchar	40	0	0
ShippedDate	ShippedDate	Yes	datetime	0	0	0
ShipPostalCode	ShipPostalCode	Yes	nvarchar	10	0	0
ShipRegion	ShipRegion	Yes	nvarchar	15	0	0
ShipVia	ShipVia	Yes	int	0	10	0

Code generation information

Setting values

Order (Entity)

Setting name	Value
Entity base class name	CommonEntityBase

CustomerId (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

Freight (NormalField)

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

OrderDate (NormalField)

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

OrderId (NormalField)

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

RequiredDate (NormalField)

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

ShipAddress (NormalField)

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

ShipCity (NormalField)

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

ShipCountry (NormalField)

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

ShipName (NormalField)

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

ShippedDate (NormalField)

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

ShipPostalCode (NormalField)

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

ShipRegion (NormalField)

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

ShipVia (NormalField)

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

Customers (NavigatorSingleValue)

Setting name	Value
Navigator property is public	True

Employees (NavigatorSingleValue)

Setting name	Value
Navigator property is public	True

OrderDetails (NavigatorCollection)

Setting name	Value
Navigator property is public	True

Products (NavigatorCollection)

Setting name	Value
Navigator property is public	True

Shippers (NavigatorSingleValue)

Setting name	Value
Navigator property is public	True

Attribute definitions per element

CustomerId (NormalField)

• StringLength

ShipAddress (NormalField)

• StringLength

ShipCity (NormalField)

• StringLength

ShipCountry (NormalField)

• StringLength

ShipName (NormalField)

• StringLength

ShipPostalCode (NormalField)

• StringLength

ShipRegion (NormalField)

• StringLength

Customers (NavigatorSingleValue)

• Browsable($true)

Employees (NavigatorSingleValue)

• Browsable($true)

Shippers (NavigatorSingleValue)

• Browsable($true)

Additional interface definitions per element

None.

Additional namespace definitions per element

None.