ADORecordset objects in OLE DB .NET Data Provider applications

When you use ADORecordset objects, you must know which framework is being used and how each object you use maps to an ADORecordset object.
Considerations regarding the use of ADORecordset objects.
  • The ADO type adDBTime class is mapped to the .NET Framework DateTime class. OleDbType.DBTime corresponds to a TimeSpan object.
  • You cannot assign a TimeSpan object to an ADORecordset object's Time field. This is because the ADORecordset object's Time field expects a DateTime object. When you assign a TimeSpan object to an ADORecordset object, you will get the following message: 
    Method's type signature is not Interop compatible.
    You can only populate the Time field with a DateTime object, or a String that can be parsed into a DateTime object.
  • When you fill a DataSet with a ADORecordset using the OleDbDataAdapter, the Time field in the ADORecordset is converted to a TimeSpan column in the DataSet.
  • Recordsets do not store primary keys or constraints. Therefore, no key information is added when filling out a DataSet from a Recordset using the MissingSchemaAction.AddWithKey.