What is the difference between an ADO.NET Dataset and an ADO Recordset ?

 Posted by Bharathi Cherukuri on 5/22/2012 | Category: ADO.NET Interview questions | Views: 5503 | Points: 40

The differences between ADO.NET Dataset and an ADO Recordset are as follows :

1) Dataset can fetch source data from many tables at a time, whereas for Recordset you can achieve the same only using the SQL joins.

2) A DataSet can represent an entire relational database in memory, complete with tables, relations, and views. A Recordset cannot do the same.

3) A DataSet is designed to work without any continuous connection to the original data source. Recordset maintains continuous connection with the original data source.

4) DataSets have no current record pointer, you can use For Each loops to move through the data. Recordsets have pointers to move through them.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response