FairCom ADO.NET Driver - Developer's Guide

Data Type Mapping - C# Edition

The following table lists the mapping between FairCom DB SQL data types and the .NET Framework types. It also lists DbTypes and .NET Framework typed accessors:

FairCom DB SQL Data Type	DbType	.NET Framework Type	.NET Framework Typed Accessor
Bigint	Int64	Int64	GetInt64()
Binary	Binary	Byte[]	GetBytes()
Bit	Boolean	Boolean	GetBoolean()
Character	AnsiString FixedLength	String	GetString() GetBytes()
Date	DateTime1	DateTime1	GetDateTime()
Float	Double	Double	GetDouble()
Integer	Int32	Int32	GetInt32()
LVarChar	Byte[]	Byte[]	GetBytes()
LVarBinary	Byte[]	Byte[]	GetBytes()
Money	Decimal	Decimal	GetDecimal()
Numeric	Decimal	Decimal	GetDecimal()
Real	Single	Single	GetSingle()
SmallInt	Int16	Int16	GetInt16()
Time	DateTime2	DateTime2	GetDateTime()
TimeStamp	DateTime2	DateTime2	GetDateTime()
TinyInt	SByte	SByte	GetInt16()
Varchar	String	String	GetString() GetBytes()
VarBinary	Byte[]	Byte[]	GetBytes()

^{1The time portion of DateTime is set to hour = 0, minute = 0, second = 0 and milliseconds = 0.}

^{2The date portion of DateTime is set to year = 1, month = 1 and day = 1.}