Poonam Jain
Explain difference between ADO and ADO.Net???
By Poonam Jain in ADO.NET on Apr 18 2009
  • Keerthi Venkatesan
    Jun, 2016 6

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

    • 0
  • Umar Ali
    Sep, 2012 1

    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

    • 0
  • Nikhil Kumar
    Apr, 2009 19

    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


    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS