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

 Posted by deccansoft on 10/30/2010 | Category: ASP.NET Interview questions | Views: 1436

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

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response