CustomersT

Inheritance hierarchy

Hierarchy type None
Is abstract False

Relationships

None.

Fields

Warning!

This entity doesn't have any identifying (primary key) fields set, so using this entity in regular operations like updating or deleting might be limited on the chosen target framework.

The following fields are defined in the CustomersT entity

Name Type Is PK Is FK Optional Read-only Max. length Precision Scale
CustomerId string (System.String) 5 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
Address string (System.String) Yes 60 0 0
City string (System.String) Yes 15 0 0
PostalCode string (System.String) Yes 10 0 0
Country string (System.String) Yes 15 0 0
Fax string (System.String) Yes 24 0 0
Tstamp byte[] (System.Byte[]) Yes 0 0 0

Unique Constraints

The following unique constraints are defined at the entity level

Name Fields
CompanyNameTs CompanyName

None.

Mappings

Northwind.dbo.Customers_TS (SQL Server (SqlClient))

Aspect Value
Type of target Table
Actions allowed Retrieve
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
CustomerId CustomerID nchar 5 0 0
Fax Fax Yes nvarchar 24 0 0
PostalCode PostalCode Yes nvarchar 10 0 0
Tstamp TStamp timestamp 0 0 0
Unmapped fields in target
Target field Nullable Type Length Precision Scale
Region Yes nvarchar 15 0 0
Phone Yes nvarchar 24 0 0

Code generation information

Setting values

CustomersT (Entity)

Setting name Value
Entity base class name CommonEntityBase

Address (NormalField)

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

City (NormalField)

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

CompanyName (NormalField)

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

ContactName (NormalField)

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

ContactTitle (NormalField)

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

Country (NormalField)

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

CustomerId (NormalField)

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

Fax (NormalField)

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

PostalCode (NormalField)

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

Tstamp (NormalField)

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

Attribute definitions per element

Address (NormalField)

  • StringLength

City (NormalField)

  • StringLength

CompanyName (NormalField)

  • StringLength

ContactName (NormalField)

  • StringLength

ContactTitle (NormalField)

  • StringLength

Country (NormalField)

  • StringLength

CustomerId (NormalField)

  • StringLength

Fax (NormalField)

  • StringLength

PostalCode (NormalField)

  • StringLength

Additional interface definitions per element

None.

Additional namespace definitions per element

None.