Product

Inheritance hierarchy

Hierarchy type	None
Is abstract	False

Relationships

The Product entity is part of the following relationships

Related Entity	Full description
Category	Product.Category - Category.Products (m:1)
Supplier	Product.Suppliers - Supplier.Products (m:1)
TCTester	TCTester.Product - Product.TCTester (m:1)
TestGroup.Order	Product.Orders - TestGroup.Order.Products (m:n) (via TestGroup.OrderDetails)
TestGroup.OrderDetails	TestGroup.OrderDetails.Products - Product.OrderDetails (m:1)

Fields

The following fields are defined in the Product entity

Name	Type	Is PK	Is FK	Optional	Read-only	Max. length	Precision	Scale
CategoryId	int (System.Int32)		Yes	Yes		0	0	0
Discontinued	bool (System.Boolean)					0	0	0
PreferredProduct	bool (System.Boolean)			Yes		0	0	0
ProductId	int (System.Int32)	Yes			Yes	0	0	0
ProductName	string (System.String)					40	0	0
QuantityPerUnit	string (System.String)			Yes		20	0	0
ReorderLevel	short (System.Int16)			Yes		0	0	0
SupplierId	int (System.Int32)		Yes	Yes		0	0	0
UnitPrice	decimal (System.Decimal)			Yes		0	19	4
UnitsInStock	short (System.Int16)			Yes		0	0	0
UnitsOnOrder	short (System.Int16)			Yes		0	0	0

Unique Constraints

None.

Fields mapped onto related fields

None.

Mappings

Northwind.dbo.Products (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
CategoryId	CategoryID	Yes	int	0	10	0
Discontinued	Discontinued		bit	0	0	0
PreferredProduct	PreferredProduct	Yes	bit	0	0	0
ProductId	ProductID		int	0	10	0	SCOPE_IDENTITY()
ProductName	ProductName		nvarchar	40	0	0
QuantityPerUnit	QuantityPerUnit	Yes	nvarchar	20	0	0
ReorderLevel	ReorderLevel	Yes	smallint	0	5	0
SupplierId	SupplierID	Yes	int	0	10	0
UnitPrice	UnitPrice	Yes	money	0	19	4
UnitsInStock	UnitsInStock	Yes	smallint	0	5	0
UnitsOnOrder	UnitsOnOrder	Yes	smallint	0	5	0

Code generation information

Setting values

Product (Entity)

Setting name	Value
Entity base class name	CommonEntityBase

CategoryId (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

Discontinued (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

PreferredProduct (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

ProductId (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

ProductName (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

QuantityPerUnit (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

ReorderLevel (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

SupplierId (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

UnitPrice (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

UnitsInStock (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

UnitsOnOrder (NormalField)

Setting name	Value
Generate as nullable type	True
Field property is public	True
Field property has private setter	False

Category (NavigatorSingleValue)

Setting name	Value
Navigator property is public	True

OrderDetails (NavigatorCollection)

Setting name	Value
Navigator property is public	True

Orders (NavigatorCollection)

Setting name	Value
Navigator property is public	True

Suppliers (NavigatorSingleValue)

Setting name	Value
Navigator property is public	True

TCTester (NavigatorCollection)

Setting name	Value
Navigator property is public	True

Attribute definitions per element

ProductName (NormalField)

• StringLength

QuantityPerUnit (NormalField)

• StringLength

Category (NavigatorSingleValue)

• Browsable($true)

Suppliers (NavigatorSingleValue)

• Browsable($true)

Additional interface definitions per element

None.

Additional namespace definitions per element

None.