Can you explain the difference between an ADO.NET Dataset and an ADO Recordset

Home >> Dot Net Interview Questions >> Ado.net Interview Questions

Posted on April 27th , 2009 by Admin

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.