Differentiate between Dataset and Recordset.

Answer Posted / skmdali786

Similar to the DataSet, a Recordset could be disconnected from
its data store and therefore act as an in-memory cache of
data. Of course, it could also be used in a connected model
depending on the cursor options that were set. Although the
Recordset object stored multiple versions of each column for
each of its rows, it was not by nature able to represent
multiple tables without the use of the Data Shape Provider.
The Recordset was not XML-based and could not be serialized to
XML easily or flexibly. Finally, a Recordset was not
independent of a data store because it tracked a Connection
object and through its methods could send queries to the data
source to populate, update, and refresh its data. To that end,
the Recordset contained functionality found in the ADO.NET
DataSet, data reader, and data adapter objects.

Is This Answer Correct ?    17 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits of using ado.net?

517


What is connection in ado.net?

532


What is sqldatasource?

523


differences between ADO and ADO.NET

570


What is the advantage of ado.net?

541






Why do we use sqldataadapter?

479


What is difference in record set and dataset?

534


Is datareader faster than datatable?

535


Define atomicity?

575


What are the features of ado.net?

499


Why edit is not possible in repeater?

522


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

548


What is ado recordset?

498


What is DataRowCollection?

623


What is an orm, and why would you use one instead of plain old ado.net?

572