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.

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.