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

differance between checkbox and rediobutton in vb.net?

1 Answers  


What makes .net core cross platform?

0 Answers  


Explain the garbage collection process?

0 Answers  


What are pdbs?

0 Answers  


What is Assembly manifest? what all details the assembly manifest will contain.

2 Answers   Ksb,


what is the meaning silverligt control

0 Answers  


Is .net core free?

0 Answers  


What base class do all Web Forms inherit from?

1 Answers  


Why DLL files are needed. & how They are Created in DOTNET?

1 Answers  


Describe the difference between inline and code behind which is best in a loosely coupled solution?

1 Answers  


what is prototype design pattern in .net

0 Answers   Infosys,


How is a managed code executed?

1 Answers  


Categories