What are good ADO.NET object(s) to replace the ADO
Recordset object.



What are good ADO.NET object(s) to replace the ADO Recordset object...

Answer / ch.raviteja

The differences includes
In ADO, the in-memory representation of data is the Recordset.
In ADO.net, it is the dataset

A recordset looks like a single table in ADO
In contrast, a dataset is a collection of one or more tables in ADO.net

ADO is designed primarily for connected access
ADO.net the disconnected access to the database is used

In ADO you communicate with the database by making calls to an OLE DB provider.
In ADO.NET you communicate with the database through a data adapter (an OleDbDataAdapter, SqlDataAdapter, OdbcDataAdapter, or OracleDataAdapter object), which makes calls to an OLE DB provider or the APIs provided by the underlying data source.

In ADO you cant update the database from the recordset. ADO.NET the data adapter allows you to control how the changes to the dataset are transmitted to the database.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Dot Net General Interview Questions

Explain acid properties?

1 Answers  


What is Method Overriding? How to override a function in C#?

1 Answers  


What is the use of Treeview control?

0 Answers   CGI,


Please explain what do the terms “boxing” and “unboxing” mean?

0 Answers  


What are the fundamental objects in ADO.NET?

1 Answers  






Should I use readerwriterlock instead of monitor.enter/exit?

0 Answers  


What is IIS and how we deploy website on IIS.

2 Answers   NetLink,


What is the use of UML in .Net

0 Answers  


Explain how com+ related to the dna architecture?

0 Answers  


Tell me about secure socket layer? How to make use of the technology?

0 Answers  


Which server tag comes from server when we submit any data

1 Answers  


How is development of a Windows service different from a Windows Forms application?

1 Answers  


Categories