Member Name |
Description |
BigInt |
A 64-bit signed integer ( DBTYPE_I8 ). This maps to Int64. |
Binary |
A stream of binary data ( DBTYPE_BYTES ). This maps to an Array of type Byte. |
Boolean |
A boolean value ( DBTYPE_BOOL ). This maps to Boolean. |
BSTR |
A null-terminated character string of Unicode characters ( DBTYPE_BSTR ). This maps to String. |
Char |
A character string ( DBTYPE_STR ). This maps to String. |
Currency |
A currency value ranging from -263 ( or -922,337,203,685,477.5808 ) to 2 63 -1 ( or +922,337,203,685,477.5807 ) with an accuracy to a ten-thousandth of a currency unit ( DBTYPE_CY ). This maps to Decimal. |
Date |
Date data, stored as a double ( DBTYPE_DATE ). The whole portion is the number of days since December 30, 1899, while the fractional portion is a fraction of a day. This maps to DateTime. |
DBDate |
Date data in the format yyyymmdd ( DBTYPE_DBDATE ). This maps to DateTime. |
DBTime |
Time data in the format hhmmss ( DBTYPE_DBTIME ). This maps to TimeSpan. |
DBTimeStamp |
Data and time data in the format yyyymmddhhmmss ( DBTYPE_DBTIMESTAMP ). This maps to DateTime. |
Decimal |
A fixed precision and scale numeric value between -1038 -1 and 10 38 -1 ( DBTYPE_DECIMAL ). This maps to Decimal. |
Double |
A floating point number within the range of -1.79E +308 through 1.79E +308 ( DBTYPE_R8 ). This maps to Double. |
Empty |
No value ( DBTYPE_EMPTY ). This maps to Empty. |
Error |
A 32-bit error code ( DBTYPE_ERROR ). This maps to Exception. |
Filetime |
A 64-bit unsigned integer representing the number of 100-nanosecond intervals since January 1, 1601 ( DBTYPE_FILETIME ). This maps to DateTime. |
Guid |
A globally unique identifier ( or GUID ) ( DBTYPE_GUID ). This maps to Guid. |
IDispatch |
A pointer to an IDispatch interface ( DBTYPE_IDISPATCH ). This maps to Object.
NOTE: This data type is not currently supported by ADO.NET. Usage may cause unpredictable results.
|
Integer |
A 32-bit signed integer ( DBTYPE_I4 ). This maps to Int32. |
IUnknown |
A pointer to an IUnknown interface ( DBTYPE_UNKNOWN ). This maps to Object.
NOTE: This data type is not currently supported by ADO.NET. Usage may cause unpredictable results.
|
LongVarBinary |
A long binary value ( OleDbParameter only ). This maps to an Array of type Byte. |
LongVarChar |
A long string value ( OleDbParameter only ). This maps to String. |
LongVarWChar |
A long null-terminated Unicode string value ( OleDbParameter only ). This maps to String. |
Numeric |
An exact numeric value with a fixed precision and scale ( DBTYPE_NUMERIC ). This maps to Decimal. |
PropVariant |
An automation PROPVARIANT ( DBTYPE_PROP_VARIANT ). This maps to Object. |
Single |
A floating point number within the range of -3.40E +38 through 3.40E +38 ( DBTYPE_R4 ). This maps to Single. |
SmallInt |
A 16-bit signed integer ( DBTYPE_I2 ). This maps to Int16. |
TinyInt |
A 8-bit signed integer ( DBTYPE_I1 ). This maps to SByte. |
UnsignedBigInt |
A 64-bit unsigned integer ( DBTYPE_UI8 ). This maps to UInt64. |
UnsignedInt |
A 32-bit unsigned integer ( DBTYPE_UI4 ). This maps to UInt32. |
UnsignedSmallInt |
A 16-bit unsigned integer ( DBTYPE_UI2 ). This maps to UInt16. |
UnsignedTinyInt |
A 8-bit unsigned integer ( DBTYPE_UI1 ). This maps to Byte. |
VarBinary |
A variable-length stream of binary data ( OleDbParameter only ). This maps to an Array of type Byte. |
VarChar |
A variable-length stream of non-Unicode characters ( OleDbParameter only ). This maps to String. |
Variant |
A special data type that can contain numeric, string, binary, or date data, as well as the special values Empty and Null ( DBTYPE_VARIANT ). This type is assumed if no other is specified. This maps to Object. |
VarNumeric |
A variable-length numeric value ( OleDbParameter only ). This maps to Decimal. |
VarWChar |
A variable-length, null-terminated stream of Unicode characters ( OleDbParameter only ). This maps to String. |
WChar |
A null-terminated stream of Unicode characters ( DBTYPE_WSTR ). This maps to String. |