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

Fields mapped onto related fields

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