Forums » .NET » .NET »

What r the differences between ADO and ADO.NET?


Posted Date: 17 Mar 2006      Posted By:: snimmakayala     Member Level: Silver    Member Rank: 0     Points: 2   Responses: 9



What r the differences between ADO and ADO.NET?



Responses

#44489    Author: Pankaj Mishra      Member Level: Gold      Member Rank: 51     Date: 17/Mar/2006   Rating: 2 out of 52 out of 5     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

Regards,
Pankaj


 
#44490    Author: HimaBindu Vejella      Member Level: Gold      Member Rank: 43     Date: 17/Mar/2006   Rating: 2 out of 52 out of 5     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

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


 
#71806    Author: DotNetGuts (DNG)      Member Level: Gold      Member Rank: 70     Date: 26/Aug/2006   Rating: 2 out of 52 out of 5     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.

DotNetGuts (DNG)





 
#140769    Author: Ashwini Rupert      Member Level: Gold      Member Rank: 129     Date: 31/Jul/2007   Rating: 2 out of 52 out of 5     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


 
#155159    Author: ChandraShekar Thota      Member Level: Gold      Member Rank: 36     Date: 29/Sep/2007   Rating: 2 out of 52 out of 5     Points: 2

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    Author: RobinHood      Member Level: Gold      Member Rank: 45     Date: 14/Aug/2008   Rating: 2 out of 52 out of 5     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.

Regards
Sridhar R
Nothing is illegal, Until You Get Caught


 
#289451    Author: Ultimaterengan      Member Level: Gold      Member Rank: 10     Date: 29/Aug/2008   Rating: 2 out of 52 out of 5     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.



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



 
#293228    Author: Bunty      Member Level: Gold      Member Rank: 15     Date: 09/Sep/2008   Rating: 2 out of 52 out of 5     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


Thanks & Regards


Bunty


 
#320217    Author: vibhaw      Member Level: Bronze      Member Rank: 0     Date: 24/Nov/2008   Rating: 2 out of 52 out of 5     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...


 
Post Reply

 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.



Next : Is there any expert to solve this?
Previous : what is difference between String and string(data type) in c#?
Return to Discussion Forum
Post New Message
Category: .NET

Related Messages

Subscribe to Subscribers
Active Members
TodayLast 7 Daysmore...

Awards & Gifts
Talk to Webmaster Tony John
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India