Specifies Adaptive Server datatypes. See Table 5-2 for details on datatype mappings.
Binary
Bit
Char
Date
DateTime
Decimal
Double
Float
Integer
Image
LongVarChar
Money
Nchar
Numeric
NVarChar
Real
SmallDateTime
SmallMoney
Text
Time
TimeStamp
TinyInt
UniChar
UniVarChar
VarBinary
VarChar
Numeric and Decimal are limited to a precision of 26, rather than 38, the precision of Adaptive Server.
The following table shows 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 |