AdoDbx.NET Data Types

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