1.

Can You Explain The Difference Between An Ado.net Dataset And An Ado Recordset?

Answer»

Valid answers are:

  • A DataSet can represent an ENTIRE relational database in memory, complete with tables, RELATIONS, and views.
  • A DataSet is designed to work WITHOUT any continuing CONNECTION to the original data source.
  • Data in a DataSet is bulk-loaded, rather than being loaded on demand.

There's no concept of cursor types in a DataSet.

  • DataSets have no current record pointer You can use For Each loops to MOVE through the data.
  • You can store many edits in a DataSet, and write them to the original data source in a single operation.
  • Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.

Valid answers are:

There's no concept of cursor types in a DataSet.


Discussion

No Comment Found

Related InterviewSolutions