AseDbType enum

Specifies Adaptive Server datatypes. See Table 5-2 for details on datatype mappings.

Members

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

NoteNumeric and Decimal are limited to a precision of 26, rather than 38, the precision of Adaptive Server.

Datatype mapping

The following table shows the datatype mappings in Adaptive Server ADO.NET Data Provider.

Table 5-2: Adaptive Server ADO.NET datatype mappings

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