Data Types Supported : Supported Data Types : ADO.NET Client

ADO.NET Client

The following table lists the data types that the ADO.NET Client supports for the OpenAccess SDK SQL engine:

Table 44: Mapping OpenAccess SDK Data Types to .NET Framework Data Types
OpenAccess Data Type	.NET Framework Type
BIGINT	Int64
BINARY	Byte[]
BIT	Boolean
CHAR	String Char[]
DATE	DateTime
DOUBLE	Double
FLOAT	Double
INTEGER	Int32
LONGVARBINARY	Byte[]
LONGVARCHAR	String
NUMERIC(p,s)	Decimal
REAL	Single
SMALLINT	Int16
TINYINT	Byte[]
TIME	TimeSpan
TIMESTAMP	DateTime
VARBINARY	Byte[]
VARCHAR	String Char[]
WCHAR	String
WLONGVARCHAR	String
WVARCHAR	String