TvGetOrdersForCustomer

Fields

The following fields are defined in the TvGetOrdersForCustomer typed view

Name Type Optional Read-only Max. length Precision Scale
CustomerId string (System.String) Yes 5 0 0
EmployeeId int (System.Int32) Yes 0 10 0
Freight decimal (System.Decimal) Yes 0 19 4
OrderDate datetime (System.DateTime) Yes 0 0 0
OrderId int (System.Int32) 0 10 0
RequiredDate datetime (System.DateTime) Yes 0 0 0
ShipAddress string (System.String) Yes 60 0 0
ShipCity string (System.String) Yes 15 0 0
ShipName string (System.String) Yes 40 0 0
ShippedDate datetime (System.DateTime) Yes 0 0 0
ShipRegion string (System.String) Yes 15 0 0
ShipVia int (System.Int32) Yes 0 10 0

Mappings

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

Type of target: Table valued function resultset

Typed View Field Target field Nullable Type Length Precision Scale Type converter
CustomerId CustomerID Yes nchar 5 0 0
EmployeeId EmployeeID Yes int 0 10 0
Freight Freight Yes money 0 19 4
OrderDate OrderDate Yes datetime 0 0 0
OrderId OrderID int 0 10 0
RequiredDate RequiredDate Yes datetime 0 0 0
ShipAddress ShipAddress Yes nvarchar 60 0 0
ShipCity ShipCity Yes nvarchar 15 0 0
ShipName ShipName Yes nvarchar 40 0 0
ShippedDate ShippedDate Yes datetime 0 0 0
ShipRegion ShipRegion Yes nvarchar 15 0 0
ShipVia ShipVia Yes int 0 10 0
Unmapped fields in target
Target field Nullable Type Length Precision Scale
ShipPostalCode Yes nvarchar 10 0 0
ShipCountry Yes nvarchar 15 0 0

Code generation information

Setting values

TvGetOrdersForCustomer (TypedView)

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

CustomerId (TypedViewField)

Setting name Value
Generate as nullable type True

EmployeeId (TypedViewField)

Setting name Value
Generate as nullable type True

Freight (TypedViewField)

Setting name Value
Generate as nullable type True

OrderDate (TypedViewField)

Setting name Value
Generate as nullable type True

OrderId (TypedViewField)

Setting name Value
Generate as nullable type True

RequiredDate (TypedViewField)

Setting name Value
Generate as nullable type True

ShipAddress (TypedViewField)

Setting name Value
Generate as nullable type True

ShipCity (TypedViewField)

Setting name Value
Generate as nullable type True

ShipName (TypedViewField)

Setting name Value
Generate as nullable type True

ShippedDate (TypedViewField)

Setting name Value
Generate as nullable type True

ShipRegion (TypedViewField)

Setting name Value
Generate as nullable type True

ShipVia (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.