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

How do you instantiate a complex number?

0 Answers  


Explain me what is the difference between a class and an object, and how do these terms relate to each other?

0 Answers  


How do you create threading in .NET? What is the namespace for that?

2 Answers  


What is the concept of inheritance in .net?

0 Answers  


What does cli do?

0 Answers  






Explain what is the difference between a class and an object, and how do these terms relate to each other?

0 Answers  


Difference between class and interface in .net?

0 Answers  


Integer & struct are value types or reference types in .NET?

1 Answers  


Why MVC programming model preferred?

1 Answers  


Write code for fetch record nos 15 to 25 from a dataset containing 50 records?

4 Answers   C Squared Systems,


With these events, why wouldn't microsoft combine invalidate and paint, so that you wouldn't have to tell it to repaint, and then to force it to repaint?

0 Answers  


What is the use of immutability?

0 Answers  


Categories