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 |