ADO Type Mapping to a .NET Framework Type
Collapse the table of content
Expand the table of content

ADO Type Mapping to a .NET Framework Type

.NET Framework 1.1

Values in the ADO Recordset or Record object are converted to .NET Framework types for storage in the DataSet. The following table shows the mapping of ADO types to .NET Framework types.

ADO type.NET Framework type
adEmptynull
adBooleanInt16
adTinyIntSByte
adSmallIntInt16
adIntegerInt32
adBigIntInt64
adUnsignedTinyIntpromoted to Int16
adUnsignedSmallIntpromoted to Int32
adUnsignedIntpromoted to Int64
adUnsignedBigIntpromoted to Decimal
adSingleSingle
adDoubleDouble
adCurrencyDecimal
adDecimalDecimal
adNumericDecimal
adDateDateTime
adDBDateDateTime
adDBTimeDateTime
adDBTimeStampDateTime
adFileTimeDateTime
adGUIDGuid
adErrorExternalException
adIUnknownobject
adIDispatchobject
adVariantobject
adPropVariantobject
adBinarybyte[]
adCharstring
adWCharstring
adBSTRstring
adChapternot supported
adUserDefinednot supported
adVarNumericnot supported

See Also

Accessing an ADO Recordset or Record from ADO.NET

Show:
© 2016 Microsoft