RAD Studio for Microsoft .NET |  |

AdoDbx.NET Data Types
AdoDbx and .NET Framework | Data Types | DB2 | InterBase | MS SQL and MSDE | Oracle | Sybase | See Also
Collapse All

AdoDbx Client data types map to .NET logical types. Dependant upon the database, AdoDbx Client data types map to native data types. Where applicable, AdoDbx Client provides:

- Consistent data type mapping across databases.
- Logical data types mapped to .NET native types.

AdoDbx and .NET Framework

The DataSet class within ADO.NET uses .NET Framework data types. AdoDbx Client data types logically map .NET data types for supported databases. During designtime, you can use AdoDbx Client logical types, which will map to the appropriate native type.

Data Types

The .NET Framework includes a wide range of logical data types. AdoDbx Client inherits logical data types, providing built-in mappings to supported databases. AdoDbx Client supports logical data type mappings for DB2, InterBase, MS SQL, MSDE, and Oracle.

DB2

AdoDbx Client supports the following DB2 type mappings.

DB2 Type | Bdp Type | BdpSubType | System.Type
CHAR | String | stFixed | String
VARCHAR | String | NA | String
SMALLINT | Int16 | NA | Int16
BIGINT | Int64 | NA | Int64
INTEGER | Int32 | NA | Int32
DOUBLE | Double | NA | Double
FLOAT | Float | NA | Single
REAL | Float | NA | Single
DATE | Date | NA | DateTime
TIME | Time | NA | DateTime
TIMESTAMP | Datetime | NA | DateTime
NUMERIC | Decimal | NA | Decimal
DECIMAL | Decimal | NA | Decimal
BLOB | Blob | stBinary | Byte[]
CLOB | Blob | stMemo | Char[]

InterBase

AdoDbx Client supports the following InterBase type mappings.

InterBase Type | Bdp Type | BdpSubType | System.Type
CHAR | String | stFixed | String
VARCHAR | String | NA | String
SMALLINT | Int16 | NA | Int16
INTEGER | Int32 | NA | Int32
FLOAT | Float | NA | Single
DOUBLE | Double | NA | Double
BLOB Sub_Type 0 | Blob | stBinary | Byte[]
BLOB Sub_Type 1 | Blob | stMemo | Char[]
TIMESTAMP | Datetime | NA | DateTime

MS SQL and MSDE

AdoDbx Client supports the following MS SQL and MSDE type mappings.

MSSQL Type | Bdp Type | BdpSubType | System.Type
BIGINT | Int64 | NA | Int64
INT | Int32 | NA | Int32
SMALLINT | Int16 | NA | Int16
TINYINT | Int16 | NA | Int16
BIT | Boolean | NA | Boolean
DECIMAL | Decimal | NA | Decimal
NUMERIC | Decimal | NA | Decimal
MONEY | Decimal | NA | Decimal
SMALLMONEY | Decimal | NA | Decimal
FLOAT | Double | NA | Double
REAL | Float | NA | Single
DATETIME | DateTime | NA | DateTime
SMALLDATETIME | DateTime | NA | DateTime
CHAR | String | stFixed | String
VARCHAR | String | NA | String
TEXT | Blob | stMemo | Char[]
BINARY | VarBytes | NA | Byte[]
VARBINARY | VarBytes | NA | Byte[]
IMAGE | Blob | stBinary | Byte[]
TIMESTAMP | VarBytes | NA | Byte[]
UNIQUEIDENTIFIER | Guid | NA | Guid

Oracle

AdoDbx Client supports the following Oracle type mappings.

Oracle Type | Bdp Type | BdpSubType | System.Type
CHAR | String | stFixed | String
NCHAR | String | stFixed | String
VARCHAR | String | NA | String
NVARCHAR | String | NA | String
VARCHAR2 | String | NA | String
NVARCHAR2 | String | NA | String
NUMBER | Decimal | NA | Decimal
DATE | Date | NA | DateTime
BLOB | Blob | stHBinary | Byte[]
CLOB | Blob | stHMemo | Char[]
LONG | Blob | stMemo | Char[]
LONG RAW | Blob | stBinary | Byte[]
BFILE | Blob | stBFile | Char[]
ROWID | String | NA | String

Sybase

AdoDbx Client supports the following Sybase type mappings.

Sybase Type | Bdp Type | BdpSubType | System.Type
CHAR | String | stFixed | String
VARCHAR | String | NA | String
INT | Int32 | NA | Int32
SMALLINT | Int16 | NA | Int16
TINYINT | Int16 | NA | Int16
DOUBLE PRECISION | Float | NA | Single
FLOAT | Float | NA | Single
REAL | Float | NA | Single
NUMERIC | Decimal | NA | Decimal
DECIMAL | Decimal | NA | Decimal
SMALLMONEY | Decimal | NA | Decimal
MONEY | Decimal | NA | Decimal
SMALLDATETIME | DateTime | NA | DateTime
DATETIME | DateTime | NA | DateTime
IMAGE | Blob | stBinary | Byte[]
TEXT | Blob | stMemo | Char[]
BIT | Boolean | NA | Boolean
TIMESTAMP | VarBytes | NA | Byte[]
BINARY | Bytes | NA | Byte[]
VARBINARY | VarBytes | NA | Byte[]
SYSNAME | String | NA | String

See Also

ADO.NET Overview

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!