Supplier

Inheritance hierarchy

Hierarchy type	None
Is abstract	False

Relationships

The Supplier entity is part of the following relationships

Related Entity	Full description
Category	Category.Suppliers - Supplier.Category (m:n) (via Product)
Product	Product.Suppliers - Supplier.Products (m:1)

Fields

The following fields are defined in the Supplier entity

Name	Type	Is PK	Is FK	Optional	Read-only	Max. length	Precision	Scale
Address	string (System.String)			Yes		60	0	0
City	string (System.String)			Yes		15	0	0
CompanyName	string (System.String)					40	0	0
ContactName	string (System.String)			Yes		30	0	0
ContactTitle	string (System.String)			Yes		30	0	0
Country	string (System.String)			Yes		15	0	0
Fax	string (System.String)			Yes		24	0	0
HomePage	string (System.String)			Yes		1073741823	0	0
Id	int (System.Int32)	Yes			Yes	0	0	0
Phone	string (System.String)			Yes		24	0	0
PostalCode	string (System.String)			Yes		10	0	0
Region	string (System.String)			Yes		15	0	0

Unique Constraints

None.

Fields mapped onto related fields

None.

Mappings

Northwind.dbo.Suppliers (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	Yes	nvarchar	60	0	0
City	City	Yes	nvarchar	15	0	0
CompanyName	CompanyName		nvarchar	40	0	0
ContactName	ContactName	Yes	nvarchar	30	0	0
ContactTitle	ContactTitle	Yes	nvarchar	30	0	0
Country	Country	Yes	nvarchar	15	0	0
Fax	Fax	Yes	nvarchar	24	0	0
HomePage	HomePage	Yes	ntext	1073741823	0	0
Id	SupplierID		int	0	10	0	SCOPE_IDENTITY()
Phone	Phone	Yes	nvarchar	24	0	0
PostalCode	PostalCode	Yes	nvarchar	10	0	0
Region	Region	Yes	nvarchar	15	0	0

Code generation information

Setting values

Supplier (Entity)

Setting name	Value
Entity base class name	CommonEntityBase

Address (NormalField)

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

City (NormalField)

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

CompanyName (NormalField)

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

ContactName (NormalField)

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

ContactTitle (NormalField)

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

Country (NormalField)

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

Fax (NormalField)

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

HomePage (NormalField)

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

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

PostalCode (NormalField)

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

Region (NormalField)

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

Category (NavigatorCollection)

Setting name	Value
Navigator property is public	True

Products (NavigatorCollection)

Setting name	Value
Navigator property is public	True

Attribute definitions per element

Address (NormalField)

• StringLength

City (NormalField)

• StringLength

CompanyName (NormalField)

• StringLength

ContactName (NormalField)

• StringLength

ContactTitle (NormalField)

• StringLength

Country (NormalField)

• StringLength

Fax (NormalField)

• StringLength

HomePage (NormalField)

• StringLength

Phone (NormalField)

• StringLength

PostalCode (NormalField)

• StringLength

Region (NormalField)

• StringLength

Additional interface definitions per element

None.

Additional namespace definitions per element

None.