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 |