Can you explain the difference between an ADO.NET Dataset and an ADO Record set?
By admin on Jan 5, 2007 in ASP.NET Interview Questions, Technical
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.


