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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / siddarth

dataset is nothing but in memory database for client
application.
Dataset supports bidirectional navigation and it supports
purely disconnected architecture with xml integration.
it supports plat form independency.
The above are all not supported by recordset.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

What is the use of data set in asp.net?

0 Answers  


Can we override the enablepartialrendering property of the scriptmanager class?

0 Answers  


Tell me Asp.net Method Overriding.

3 Answers  


Can the validation be done in the server side? Or this can be done only in the Client side?

2 Answers  


What are the new navigation controls in asp.net 2.0?

0 Answers  






What is the difference between an EXE and a DLL?

18 Answers   Infosys, JK Associates, Persistent, TATA, Technosoft, Wipro,


Why would a company use an application service provider?

0 Answers  


If I update session state, should I lock it, too? Are concurrent accesses by multiple requests executing on multiple threads a concern with session state?

1 Answers  


how to implement some securty aspect in our application i.e 1.cookie poisioning. 2.data encryption. 3.forcefull browsing 4.sql/code injection 5.securing web app by using web services ........my question is how to implement these thing in our application is this done by hard coding or by help of some tool

0 Answers   Satyam,


What's the use of response.output.write()?

0 Answers  


Define what is razor? : asp.net mvc

0 Answers  


what is manifest?

3 Answers   Airtel, Microsoft,


Categories