Can you explain the difference between an ADO.NET Dataset
and an ADO Recordset?

Answer Posted / ganesh

Valid answers are:
· 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 ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does asp net store session ids by default?

612


What is the difference between Hash table and Array list?

474


Why mvc is better than asp.net? : Asp.Net MVC

558


Define secured sockets layer.

603


What are the Types of state management techniques

645






What is the benefit of WebAPI over WCF?

664


Where the cookie value is stored?

607


What setting must be added in the configuration file to deny a particular user from accessing the secured resources?

589


What is caching in asp.net?

642


Describe the disadvantage of cookies.

667


Explain the use of resource manager class in .net.

598


Define managed code and managed data in .net?

597


How to include silver light .xap page into asp.net web application and what is the purpose of using silverlight application?

2344


Describe SOA and the tenets of it?

653


What is full trust in asp.net?

638