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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you write a class without specifying namespace?

792


Explain me how does linq work?

750


Explain how viewstate is being formed and how it's stored on client in .net?

732


If you are executing these statements in commandobject. Select * from table1; select * from table2? How you will deal result set? 42. How do you sort a dataset.

721


What is the difference between .net and laravel?

749


Is atl redundant in the .net world?

724


Explain the difference between managed and unmanaged code?

619


What is the difference between an abstract class and an interface?

708


Write Code for DataSet,Datareader,and by deleting the button gridview should be empty?

1904


Please explain what garbage collection is and how it works. Provide a code example of how you can enforce garbage collection in .net?

737


How many design patterns can be created in .net?

772


How will you load dynamic assembly? How will create assemblies at run time?

1851


What are the similarities and difference between class and structure in .net?

720


Is .net a language?

752


Tell about your technical profile ?

3301