TvTcgetOrdersForCustomer

Fields

The following fields are defined in the TvTcgetOrdersForCustomer 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
FreightInt int (System.Int32) 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
ShipCountry string (System.String) Yes 15 0 0
ShipName string (System.String) Yes 40 0 0
ShippedDate datetime (System.DateTime) Yes 0 0 0
ShipPostalCode string (System.String) Yes 10 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
FreightInt Freight Yes money 0 19 4 SD.LLBLGen.Pro.TypeConverters.Int32DecimalConverter
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
ShipCountry ShipCountry Yes nvarchar 15 0 0
ShipName ShipName Yes nvarchar 40 0 0
ShippedDate ShippedDate Yes datetime 0 0 0
ShipPostalCode ShipPostalCode Yes nvarchar 10 0 0
ShipRegion ShipRegion Yes nvarchar 15 0 0
ShipVia ShipVia Yes int 0 10 0

Code generation information

Setting values

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

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

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

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