You must Sign In to post a response.

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?


Comments

Author: Pankaj Mishra17 Mar 2006 Member Level: Gold   Points : 2

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

Author: HimaBindu Vejella17 Mar 2006 Member Level: Gold   Points : 2

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

Author: DotNetGuts (DNG)26 Aug 2006 Member Level: Gold   Points : 2

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.

Author: Ashwini Rupert31 Jul 2007 Member Level: Gold   Points : 2

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

Author: ChandraShekar Thota29 Sep 2007 Member Level: Gold   Points : 2

ado is connected
ado.net is disconnected

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

Author: RobinHood14 Aug 2008 Member Level: Gold   Points : 4

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.

Author: Ultimaterengan29 Aug 2008 Member Level: Gold   Points : 2

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.




Author: Bunty09 Sep 2008 Member Level: Gold   Points : 6

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

Author: vibhaw24 Nov 2008 Member Level: Bronze   Points : 6

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...


Sign In to post your comments