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
What is an ado connection?
Explain the two fundamental objects in ado.net?
What we do with the object of ado.net dataset after using it?
Which keyword is used to accept variable number of parameters?
How would you connect to a database by using .NET?
What is the provider being used to access oracle database?
Which object needs to be closed?
What is ado oledb and odbc?
Compare Data Reader & Dataset in ado.net?
What is the difference between dataset and datatable?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is datasource in ado.net?
How can we save all data from dataset?
What are the advantages of oledb compared with other classes?
What is difference between datatable and dataset?
