Mapping of Ingres Native Types to .NET Types

The following table maps the native Ingres database types supported by the .NET Data Provider to their corresponding .NET type. It also maps the typed accessor that a .NET application uses for an Ingres native database type to be obtained as a .NET type.

IngresType	Ingres Data Type	.NET Data Type	Accessor
Binary	byte	Byte[]	GetBytes()
Char	char	String	GetString()
DateTime	date	DateTime	GetDateTime()
Decimal	decimal	Decimal	GetDecimal()
Double	double precision (float8)	Double	GetDouble()
SmallInt	smallint	Int16	GetInt16()
TinyInt	integer1	Byte	GetByte()
Int	integer	Int32	GetInt32()
BigInt	bigint	Int64	GetInt64()
LongVarBinary	long byte	Byte[]	GetBytes()
LongVarChar	long varchar	String	GetString()
LongNVarChar	long nvarchar	String	GetString()
Nchar	nchar	String	GetString()
NvarChar	nvarchar	String	GetString()
Real	real (float4)	Single	GetString()
VarBinary	byte varying	Byte[]	GetBytes()
VarChar	varchar	String	GetString()
IntervalYearToMonth	interval year to month	String	GetString()
IntervalDayToSecond	interval day to second	Timespan	GetTimeSpan()