Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?
Answer Posted / ramgopal reddy
? A DataSet can represent an entire relational database in
memory, complete with tables, relations, and views.
? A DataSet is designed to work without any continuing
connection to the original data source.
? Data in a DataSet is bulk-loaded, rather than being loaded
on demand.
? There's no concept of cursor types in a DataSet.
? DataSets have no current record pointer You can use For
Each loops to move through the data.
? You can store many edits in a DataSet, and write them to
the original data source in a single operation.
? Though the DataSet is universal, other objects in ADO.NET
come in different versions for different data sources.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the benefit of WebAPI over WCF?
How can we prevent browser from caching an aspx page?
What are the Types of object in asp
What is the adavantage of using ASP.NET routing?
List some of the important session state modes of asp.net.
Differentiate the session object and application object?
Is it possible for me to change my aspx file extension to some other name?
What is autopostback in dropdownlist in asp net?
What is the differences between a primary key and a unique key in sql server?
What are HTTP handlers in ASP.NET?
What is inproc and outproc?
What is strong-typing versus weak-typing?
Which is better viewstate or session?
What is runat?
Why we use dbms for projects? Why don’t we save any application data in separate files instead of dbms?