You must Sign In to post a response.
  • Category: .NET

    What r the differences between ADO and ADO.NET?

    The forum thread has not been reviewed by Editors yet. Readers are advised to use their best judgement before accessing this thread.
    This thread will be reviewed shortly.
    If you think this thread contain inappropriate content, please report to webmaster.
    What r the differences between ADO and ADO.NET?
  • #44489
    Hi

    ADO and ADO.NET are different in several ways:

    · ADO works with connected data. This means that when you access data, such as viewing and updating data, it is real-time, with a connection being used all the time. This is barring, of course, you programming special routines to pull all your data into temporary tables.

    ADO.NET uses data in a disconnected fashion. When you access data, ADO.NET makes a copy of the data using XML. ADO.NET only holds the connection open long enough to either pull down the data or to make any requested updates. This makes ADO.NET efficient to use for Web applications. It's also decent for desktop applications.

    · ADO has one main object that is used to reference data, called the Recordset object. This object basically gives you a single table view of your data, although you can join tables to create a new set of records. With ADO.NET, you have various objects that allow you to access data in various ways. The DataSet object will actually allow you to store the relational model of your database. This allows you to pull up customers and their orders, accessing/updating the data in each related table individually.

    · ADO allows you to create client-side cursors only, whereas ADO.NET gives you the choice of either using client-side or server-side cursors. In ADO.NET, classes actually handle the work of cursors. This allows the developer to decide which is best. For Internet development, this is crucial in creating efficient applications.

    · Whereas ADO allows you to persist records in XML format, ADO.NET allows you to manipulate your data using XML as the primary means. This is nice when you are working with other business applications and also helps when you are working with firewalls because data is passed as HTML and XML.


    For more information please refer
    http://www.geekinterview.com/question_details/18555

    Regards
    Pankaj

    Regards,
    Pankaj

  • #44490
    Ado Ado.net are completely different concepts
    ADo there is record set and no native xml support
    Ado.net DataSet and Xml support

    http://himabinduvejella.blogspot.com
    http://sysntaxhelp.com/asp.net
    http://groups.google.com/group/mugh

  • #71806
    Difference between ADO and ADO.net
    1. ADO used connected data usage, while ADO.net used disconnected data environment.
    2. ADO used OLE DB to access data and is COM-based, while ADO.net uses XML as the format for transmitting data to and from your database and web application.
    3. In ADO, Record set, is like a single table or query result, while in ADO.net Dataset, can contain multiple tables from any data source.
    4. In ADO, it is sometime problematic because firewall prohibits many types of request, while in ADO.net there is no such problem because XML is completely firewall-proof.

    DotNetGuts (DNG)

  • #140769
    Hi,

    ADO.NET is stateless mechanism. I can treat the ADO.Net as a separate in-memory database where in I can use relationships between the tables and select insert and updates to the database. I can update the actual database as a batch.

    ADO and ADO.NET are different in several ways:

    · ADO works with connected data. This means that when you access data, such as viewing and updating data, it is real-time, with a connection being used all the time. This is barring, of course, you programming special routines to pull all your data into temporary tables.

    ADO.NET uses data in a disconnected fashion. When you access data, ADO.NET makes a copy of the data using XML. ADO.NET only holds the connection open long enough to either pull down the data or to make any requested updates. This makes ADO.NET efficient to use for Web applications. It's also decent for desktop applications.

    · ADO has one main object that is used to reference data, called the Recordset object. This object basically gives you a single table view of your data, although you can join tables to create a new set of records. With ADO.NET, you have various objects that allow you to access data in various ways. The DataSet object will actually allow you to store the relational model of your database. This allows you to pull up customers and their orders, accessing/updating the data in each related table individually.

    · ADO allows you to create client-side cursors only, whereas ADO.NET gives you the choice of either using client-side or server-side cursors. In ADO.NET, classes actually handle the work of cursors. This allows the developer to decide which is best. For Internet development, this is crucial in creating efficient applications.

    · Whereas ADO allows you to persist records in XML format, ADO.NET allows you to manipulate your data using XML as the primary means. This is nice when you are working with other business applications and also helps when you are working with firewalls because data is passed as HTML and XML.


    Regards,
    Ashwini

  • #155159
    ado is connected
    ado.net is disconnected

    ado is recordset based and ado.net is dataset based(xml dataset we say)

    Free Online,Offline Sessions
    www.hyderabadtechies.info

    chandrashekarthota@gmail.com /92 93 95 95 39

  • #281349
    ADO..
    1.It works with connected area.
    2.RecordSet object is there in ADO.This is used to reference data.
    3.ADO allows the user to persist records in XML
    format.

    ADO.NET..
    1.It uses data in a disconnection fashion.
    2.There are various objects that allow the user to access
    data in various ways.
    3.It allows the user to manipulate your data using
    XML as the primary means.

    Regards
    Sridhar R
    Nothing is illegal, Until You Get Caught

  • #289451
    Expansion of ADO is ActiveX Data Object.
    Ado:-
    ADO work with connected data.ADO's are stateful(TCP/IP), ADO.NET's are stateless(internet).ADO allows you to create client-side cursors only, whereas ADO.NET gives you the choice of either using client-side or server-side cursors.
    ADO.NET object is a lightweight object.Ado.Net navigate data with XML. ADO Not nevigate. Table lockings is Possible in ADO and Table Lockings is not Possible in ADO.Net.
    ADO.NET is the primary relational data access model for Microsoft Dot NET based Application.
    It works with any component on any platform that understands XML.



    Thanks & Regards
    G.Renganathan
    Nothing is mine ,Everything is yours!!!

  • #293228
    Hi,

    Followind the difference between ADo and ADO.Net

    1>ADO's are created using COM technology whereas ADO.net implemented by using .net framework technology.

    2>In ADo we can store only one table in the recordset whereas in ado.net we can store multiple tables in the dataset.

    3>In ADO we can't generate relations whereas in ado.net we can generate relations.

    4>Using ADO we can't integerate with XML whereas using ADO.netwe can integerate with XML.

    5>In the ADo's we can't send multiple transaction in the single instance whereas in ADO.net we can send multiple transaction in a single instance.

    6>In ADO's we can't generate SQL statements whereas in ADO.net we can generate SQL statement.

    Thanks and Regards
    S.S.Bajoria


    Thanks & Regards


    Bunty

  • #320217
    ADO has the same inability as ADO.NET to do parallel work on the same open
    connection. What it does is to open a second, hidden connection when you
    are executing another operation on an already busy connection. This process
    can lead to subtil and nearly untraceable bugs in situations like editing
    two open recordsets from inside a transaction. In ADO.NET, this hidden work
    under the hood have been removed: if you need two open connections, then you
    have to open these explicitly.

    Using ADO.NET you can get data back much like a result-set of ADO old. The new result objects in ADO.NET are DataSets (which in turn have DataTables which are more like resultsets), or DataReaders (which are forward only resultssets).

    Main Difference between ADo and ADo.net is that ADO uses Connected Approach ie. when we fetch the data and then alter the data it will change the data in the DataBase but ADO.NEt uses Dissconnected approach. is data fetched in dataSet can be changed or manipulated and it will not change the DataBzase the moment we change it in DataSet but it will change the database whenever we want...


This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.