What is ADO .NET and what is difference between ADO and ADO.NET?

Discussion in 'C#' started by muzam, Jul 4, 2012.

0
  1. #1
    What is ADO .NET and what is difference between ADO and ADO.NET?
    ADO.NET is a mechanism (stateless). We can treat the ADO.Net as a separate in-memory database where in we can use relationships between the tables and select insert and updates to the database. We can update the actual database as a batch.
     
    muzam, Jul 4, 2012 IP
  2. abhishekabhi

    abhishekabhi Greenhorn

    Messages:
    57
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    18
    #2
    HI

    ado.net is part of .net technology its provides method for connectivity asp.net and database.
     
    abhishekabhi, Sep 21, 2012 IP
  3. TayyabRazaq

    TayyabRazaq Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    ADO.net is the part of . net which helps to connect your application to the database....
     
    TayyabRazaq, Dec 9, 2012 IP
  4. gym.prathap

    gym.prathap Peon

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #4
    gym.prathap, Dec 26, 2012 IP
  5. funkseo

    funkseo Greenhorn

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #5
    simply ado is a accessing relational database library for languages VB6,C++,etc... before ado.net.
    Microsoft developed Ado.Net for .Net and there are several logical differences between them.
     
    funkseo, Apr 10, 2013 IP
  6. sbglobal79

    sbglobal79 Banned

    Messages:
    724
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    55
    #6
    ADO.NET is an object-oriented set of libraries that allows you to interact with data sources. Commonly, the data source is a database, but it could also be a text file, an Excel spreadsheet, or an XML file. For the purposes of this tutorial, we will look at ADO.NET as a way to interact with a data base.

    Difference between ADO and ADO.NET
    ADO

    1.It is a COM based library.
    2.Classic ADO requires active connection with the data store.
    3.Locking feature is available.
    4.Data is stored in binary format.
    5.XML integration is not possible.
    6.It uses the object named Recordset to reference data from the data store.
    7.Using Classic ADO, we can obtain information from one table or set of tables through join. We cannot fetch records from multiple tables independently.
    8.Firewall might prevent execution of Classic ADO.
    9.Classic ADO architecture includes client side cursor and server side cursor.
    10.We cannot send multiple transactions using a single connection instance.

    ADO.NET

    1.It is a CLR based library.
    2.ADO.NET architecture works while the data store is disconnected.
    3.Locking feature is not available.
    4.Data is stored in XML.
    5.XML integration is possible.
    6.It uses Dataset Object for data access and representation.
    7.Dataset object of ADO.NET includes collection of DataTables wherein each DataTable will contain records fetched from a particular table. Hence multiple table records are maintained independently.
    8.ADO.NET has firewall proof and its execution will never be interrupted.
    9.ADO.NET architecture doesn't include such cursors.
    10.We can send multiple transactions using a single connection instance.
     
    sbglobal79, Apr 10, 2013 IP
  7. svfox

    svfox Well-Known Member

    Messages:
    622
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    110
    #7
    It is more advanced. meaning for features. Disconnected recordserts being one of them.
     
    svfox, Apr 11, 2013 IP