CustomersOnCountry

Fields

The following fields are defined in the CustomersOnCountry typed view

Name Type 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
CustomerId string (System.String) 5 0 0
PostalCode string (System.String) Yes 10 0 0
Region string (System.String) Yes 15 0 0

Mappings

Northwind.dbo.pr_CustomersAndOrdersOnCountry.Resultset1 (SQL Server (SqlClient))

Type of target: Stored procedure resultset

Typed View Field Target field Nullable Type Length Precision Scale 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
PostalCode PostalCode Yes nvarchar 10 0 0
Region Region Yes nvarchar 15 0 0
Unmapped fields in target
Target field Nullable Type Length Precision Scale
Phone Yes nvarchar 24 0 0
Fax Yes nvarchar 24 0 0

Code generation information

Setting values

CustomersOnCountry (TypedView)

Setting name Value
Typed view row base class name
Output type TypedDataTable

Address (TypedViewField)

Setting name Value
Generate as nullable type True

City (TypedViewField)

Setting name Value
Generate as nullable type True

CompanyName (TypedViewField)

Setting name Value
Generate as nullable type True

ContactName (TypedViewField)

Setting name Value
Generate as nullable type True

ContactTitle (TypedViewField)

Setting name Value
Generate as nullable type True

Country (TypedViewField)

Setting name Value
Generate as nullable type True

CustomerId (TypedViewField)

Setting name Value
Generate as nullable type True

PostalCode (TypedViewField)

Setting name Value
Generate as nullable type True

Region (TypedViewField)

Setting name Value
Generate as nullable type True

Attribute definitions per element

None.

Additional interface definitions per element

None.

Additional namespace definitions per element

None.