What is the main difference between ADO and ADO.Net

Answer Posted / babina

The old ADO (ActiveX Data Object) has evolved to ADO.NET in
the .NET Framework. The ADO.NET object is a lightweight
object. The ADO Recordset was a huge object in ADO. It
provided the ability to support multiple types of cursors.
It provided fast lightweight "firehose" cursor and also
supported a disconnected client-side cursor that supported
tracking, optimistic locking, and automatic batch updates of
a central database. However, all of this functionality was
difficult to customize.
ADO.NET breaks the functionality of the ADO object to
multiple classes, thereby allowing a focused approach to
developing code. The ADO.NET DataReader is equivalent to the
"firehose" cursor. The DataSet is a disconnected cache with
tracking and control binding functionality. The DataAdapter
provides the ability to completely customize how the central
data store is updated with the changes to a DataSet.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you use stored procedure in ado.net?

542


What is the role of the dataset object in ado.net?

571


What are the advantages of ado.net?

509


Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

553


Define data adapter?

506






How can we serialize the dataset object?

558


What is dataset object? Explain the various objects in dataset.

586


What are the important features of ado.net 2.0?

592


How can we add/remove row's in "datatable" object of "dataset"?

537


What is ado control?

524


What DataReader class do in ADO.NET ?

582


Which namespaces are used for data access?

621


What is openquery?

529


What is ado.net code?

519


What are the namespaces used in ADO.Net to connect to a database?

594