3
Reply

Explain difference between ADO and ADO.Net???

Poonam Jain

Poonam Jain

15y
6.8k
0
Reply

    In ADO, the in-memory representation of data is the recordset. In ADO.NET, it is the dataset.

    Please refer to the following URL to know the differences between ADO and ADO.NET,http://onlydifferencefaqs.blogspot.in/2012/07/adonet-difference-faqs-1.html

    Hi,
    Poonam,
    Here is your answer...

    What is the difference between ADO and ADO.NET?

    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.

    For more help

    Nikhil