TypeConverterTestTv

Fields

The following fields are defined in the TypeConverterTestTv 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
Country string (System.String) Yes 15 0 0
CustomerId string (System.String) Yes 5 0 0
EmployeeId int (System.Int32) Yes 0 0 0
Freight decimal (System.Decimal) Yes 0 19 4
OrderDate datetime (System.DateTime) Yes 0 0 0
OrderId int (System.Int32) 0 0 0
PostalCode string (System.String) Yes 10 0 0
Region string (System.String) Yes 15 0 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 bool (System.Boolean) Yes 0 0 0

Mappings

Northwind.dbo.Orders Qry (SQL Server (SqlClient))

Type of target: View

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
Country Country Yes nvarchar 15 0 0
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
PostalCode PostalCode Yes nvarchar 10 0 0
Region Region Yes nvarchar 15 0 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 SD.LLBLGen.Pro.TypeConverters.BooleanNumericConverter

Code generation information

Setting values

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

Country (TypedViewField)

Setting name Value
Generate as nullable type True

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

PostalCode (TypedViewField)

Setting name Value
Generate as nullable type True

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