ASE ADO.NET datatype mappings

Table 5-2: ASE ADO.NET datatype mappings

ASEDatabase Type

AseDbType enumerated

.NET Dbtype enumerated

.Net Class Name

binary

Binary

Binary

Byte[]

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

univarchar

UniVarChar

String

String

varbinary

VarBinary

Binary

Byte[]

varchar

VarChar

AnsiString

String