Adaptive Server ADO.NET Datatype Mappings

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