ASP .NET اسئلة واجوبة المقابلات

Question: 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.