Connectivity Guide > Connectivity Guide > Understanding .NET Data Provider Connectivity > Data Types Mapping > DbType Mapping
Was this helpful?
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
Last modified date: 01/30/2023