9. Understanding .NET Data Provider Connectivity : Data Types Mapping : DbType Mapping
 
Share this page                  
DbType Mapping
.NET's System.Data.DbType for a parameter is mapped to the IngresType data type as follows:
DbType
IngresType
AnsiString
VarChar
AnsiStringFixedLength
Char
Binary
VarBinary
Boolean
Boolean
Byte
Binary, if supported by the database; otherwise, Char
Currency
Decimal
Date
DateTime
DateTime
DateTime
Decimal
Decimal
Double
Double
Guid
Not supported
Int16
SmallInt
Int32
Int
Int64
Decimal
Object
Not supported
SByte
TinyInt, if supported by the database; otherwise, SmallInt
Single
Real
String
NVarChar , if supported by the database; otherwise, VarChar
StringFixedLength
NChar, if supported by the database; otherwise, Char
Time
DateTime
UInt16
Int
UInt32
Decimal
UInt64
Decimal
VarNumeric
Decimal