OLE DB Data Type Mappings (ADO.NET)
The following table shows the inferred .NET Framework type for data types from the .NET Framework Data Provider for ADO and OLE DB (System.Data.OleDb). The typed accessor methods for the OleDbDataReader are also listed.
ADO type |
OLE DB type |
.NET Framework type |
.NET Framework typed accessor |
|---|---|---|---|
adBigInt |
DBTYPE_I8 |
Int64 |
GetInt64() |
adBinary |
DBTYPE_BYTES |
Byte[] |
GetBytes() |
adBoolean |
DBTYPE_BOOL |
Boolean |
GetBoolean() |
adBSTR |
DBTYPE_BSTR |
String |
GetString() |
adChapter |
DBTYPE_HCHAPTER |
Supported through the DataReader. See Retrieving Data Using a DataReader (ADO.NET). |
GetValue() |
adChar |
DBTYPE_STR |
String |
GetString() |
adCurrency |
DBTYPE_CY |
Decimal |
GetDecimal() |
adDate |
DBTYPE_DATE |
DateTime |
GetDateTime() |
adDBDate |
DBTYPE_DBDATE |
DateTime |
GetDateTime() |
adDBTime |
DBTYPE_DBTIME |
DateTime |
GetDateTime() |
adDBTimeStamp |
DBTYPE_DBTIMESTAMP |
DateTime |
GetDateTime() |
adDecimal |
DBTYPE_DECIMAL |
Decimal |
GetDecimal() |
adDouble |
DBTYPE_R8 |
Double |
GetDouble() |
adError |
DBTYPE_ERROR |
ExternalException |
GetValue() |
adFileTime |
DBTYPE_FILETIME |
DateTime |
GetDateTime() |
adGUID |
DBTYPE_GUID |
Guid |
GetGuid() |
adIDispatch |
DBTYPE_IDISPATCH * |
Object |
GetValue() |
adInteger |
DBTYPE_I4 |
Int32 |
GetInt32() |
adIUnknown |
DBTYPE_IUNKNOWN * |
Object |
GetValue() |
adNumeric |
DBTYPE_NUMERIC |
Decimal |
GetDecimal() |
adPropVariant |
DBTYPE_PROPVARIANT |
Object |
GetValue() |
adSingle |
DBTYPE_R4 |
Single |
GetFloat() |
adSmallInt |
DBTYPE_I2 |
Int16 |
GetInt16() |
adTinyInt |
DBTYPE_I1 |
Byte |
GetByte() |
adUnsignedBigInt |
DBTYPE_UI8 |
UInt64 |
GetValue() |
adUnsignedInt |
DBTYPE_UI4 |
UInt32 |
GetValue() |
adUnsignedSmallInt |
DBTYPE_UI2 |
UInt16 |
GetValue() |
adUnsignedTinyInt |
DBTYPE_UI1 |
Byte |
GetByte() |
adVariant |
DBTYPE_VARIANT |
Object |
GetValue() |
adWChar |
DBTYPE_WSTR |
String |
GetString() |
adUserDefined |
DBTYPE_UDT |
not supported |
|
adVarNumeric |
DBTYPE_VARNUMERIC |
not supported |
|
* For the OLE DB types DBTYPE_IUNKNOWN and DBTYPE_IDISPATCH, the object reference is a marshaled representation of the pointer.