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 ado or jdbc?
Explain the basic use of "dataview" and explain its methods.
What is sqldatasource?
What is basic use of data view?
What is a datareader object?
What are the various methods provided by the DataSet object to generate XML?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What are the several execute methods of ado.net?
What are the advantages of using datalist?
What is connection pooling and what is the maximum pool size in ado.net connection string?
What is ado.net explain with diagram?
What is microsoft ado?
What are the rules to implement connection pooling?
Does executenonquery return a value?
What are the different ado.net namespaces?