MimerDataReader.GetValue Method

Gets the column in its native format.

[Visual Basic]
Public Function GetValue( _ 
   ByVal i As Integer _ 
) _
    Implements IDataRecord.GetValue As Object
[C#]
public object GetValue(
   int i
);
[C++]
public: Object* GetValue(
   int i
);
[JScript]
public function GetValue(
   int i
): Object;

Parameters

i: The zero-based column ordinal position.

Return Value

The native format value.

Implements

IDataRecord.GetValue

Remarks

Currently the Mimer ADO.NET data provider returns values as standard .NET data types. Please note that this may change in the future. The result data type is chosen to always be able to hold the output value.

SQL Data Type	Returned .NET data type
DECIMAL, NUMERIC	Precision: 1 <= Decimal <= 28 < String <= 45
BIGINT	Int64
INTEGER	Int32
INT(precision)	precision: 1 <= Int16 < 5 <= Int32 < 10 <= Int64 < 19 <= Decimal < 29 <= String <= 45
FLOAT(precision)	String (as Mimer the FLOAT supports exponents up to 999 while the maximum for Double is 308)
DOUBLE PRECISION	Double
REAL	Single
CHAR, VARCHAR, NCHAR, NVARCHAR, CLOB, NCLOB	String
DATE, TIME, TIMESTAMP	DateTime
INTERVAL YEAR, INTERVAL MONTH	Int32
INTERVAL YEAR TO MONTH	String
INTERVAL DAY, INTERVAL HOUR, INTERVAL MINUTE, INTERVAL DAY TO HOUR, INTERVAL DAY TO MINUTE, INTERVAL DAY TO SECOND, INTERVAL HOUR TO MINUTE, INTERVAL HOUR TO SECOND, INTERVAL MINUTE TO SECOND	TimeSpan
INTERVAL SECOND(precision)	precision: 1 <= TimeSpan <= 11 < String <= 12
ODBC.GUID	Guid
BINARY, VARBINARY, BLOB	Byte []

Exceptions