Differentiate between Dataset and Recordset.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
1) With Data set you can retrive data from database like
oracle and SQL Server and manage them in one dataset, with
recordset this is not possible.
2) All representation of Dataset is using XML while
recordset uses COM.
Is This Answer Correct ? | 2 Yes | 3 No |
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What is ado.net components?
What does ADO.NET consists of ?
What is the default Timeout for SqlCommand.CommandTimeout property?
What are good ado.net object to replace to ado recordset object.
What is the difference between ado.net and oledb?
WHAT Are the major major compnents of a data provider in ADO.net.
What is acid in ado.net?
what is Execute NOn Query?
29 Answers Infosys, Protech, Sars Systems, SwanSoft Technologies,
What are the advantages of oledb compared with other classes?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
What is difference between datatable and dataset?