The datatype mappings in Adaptive Server ADO.NET Data Provider.
Adaptive Server Database Type |
AseDbType Enumerated |
.NET Dbtype Enumerated |
.NET class Name |
---|---|---|---|
binary |
Binary |
Binary |
Byte[] |
bigint |
BigInt |
Int64 |
Int64 |
bit |
Bit |
Boolean |
Boolean |
char |
Char |
AnsiStringFixedLength |
String |
date |
Date |
Date |
DateTime |
datetime |
DateTime |
DateTime |
DateTime |
decimal |
Decimal |
Decimal |
Decimal |
double |
Double |
Double |
Double |
float(<16) |
Real |
Single |
Single |
float(>=16) |
Double |
Double |
Double |
image |
Image |
Binary |
Byte[] |
int[eger] |
Integer |
Int32 |
Int32 |
money |
Money |
Currency |
Decimal |
nchar |
NChar |
AnsiStringFixedLength |
String |
nvarchar |
NVarChar |
AnsiString |
String |
numeric |
Numeric |
VarNumeric |
Decimal |
real |
Real |
Single |
Single |
smalldatetime |
SmallDateTime |
DateTime |
DateTime |
smallint |
SmallInt |
Int16 |
Int16 |
smallmoney |
SmallMoney |
Currency |
Decimal |
text |
Text |
AnsiString |
String |
time |
Time |
Time |
DateTime |
timestamp |
TimeStamp |
Binary |
Byte[] |
tinyint |
TinyInt |
Byte |
Byte |
unichar |
UniChar |
StringFixedLength |
String |
unitext |
Unitext |
String |
String |
univarchar |
UniVarChar |
String |
String |
unsignedbigint |
UnsignedBigint |
UInt64 |
UInt64 |
unsignedint |
UnsignedInt |
UInt32 |
UInt32 |
unsignedsmallint |
UnsignedSmallInt |
UInt16 |
UInt16 |
varbinary |
VarBinary |
Binary |
Byte[] |
varchar |
VarChar |
AnsiString |
String |