Customer

Inheritance hierarchy

Hierarchy type None
Is abstract False

Relationships

The Customer entity is part of the following relationships

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

Fields

The following fields are defined in the Customer entity

Name Type Is PK Is FK Optional Read-only Max. length Precision Scale
CompanyName string (System.String) 40 0 0
ContactName string (System.String) Yes 30 0 0
ContactTitle string (System.String) Yes 30 0 0
CustomerId string (System.String) Yes 5 0 0
Fax string (System.String) Yes 24 0 0
Phone string (System.String) Yes 24 0 0
PostalCode string (System.String) Yes 10 0 0
VisitingAddress AddressVt 0 0 0

Unique Constraints

The following unique constraints are defined at the entity level

Name Fields
CompanyName CompanyName

None.

Mappings

Northwind.dbo.Customers (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
ContactName ContactName Yes nvarchar 30 0 0
ContactTitle ContactTitle Yes nvarchar 30 0 0
CustomerId CustomerID nchar 5 0 0
Fax Fax Yes nvarchar 24 0 0
Phone Phone Yes nvarchar 24 0 0
PostalCode PostalCode Yes nvarchar 10 0 0
VisitingAddress.Address Address Yes nvarchar 60 0 0
VisitingAddress.City City Yes nvarchar 15 0 0
VisitingAddress.Country Country Yes nvarchar 15 0 0
VisitingAddress.Region Region Yes nvarchar 15 0 0

Code generation information

Setting values

Customer (Entity)

Setting name Value
Entity base class name CommonEntityBase

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

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

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

VisitingAddress (NormalField)

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

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

Shippers (NavigatorCollection)

Setting name Value
Navigator property is public True

Attribute definitions per element

Customer (Entity)

  • DataMember

CompanyName (NormalField)

  • StringLength

ContactName (NormalField)

  • StringLength

ContactTitle (NormalField)

  • StringLength
  • SomeAttribute

CustomerId (NormalField)

  • StringLength

Fax (NormalField)

  • StringLength

Phone (NormalField)

  • StringLength

PostalCode (NormalField)

  • StringLength

Employees (NavigatorCollection)

  • AnotherAttribute

Additional interface definitions per element

Customer (Entity)

  • IFoo

Additional namespace definitions per element

Customer (Entity)

  • System