Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 15-01-2009
Member
 
Join Date: Dec 2008
Posts: 9
Difference between ADO and ADO.NET

Can anybody please tell me,
What is the difference between ADO and ADO.NET ?
Reply With Quote
  #2  
Old 15-01-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: 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.
Reply With Quote
  #3  
Old 15-01-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: Difference between ADO and ADO.NET

  • 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.
Reply With Quote
  #4  
Old 15-01-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: Difference between ADO and ADO.NET

ADO.NET Supports.
  1. disconnected data archetecture
  2. data cached in dataset
  3. data transefer in XML format
  4. interaction with database is done through the datacommands
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Difference between ADO and ADO.NET"
Thread Thread Starter Forum Replies Last Post
What is difference between RAM and ROM? Harper 21 Motherboard Processor & RAM 5 30-01-2010 09:00 AM
Difference between OOP and AOP Sarfaraj Khan Software Development 5 20-01-2010 09:20 AM
Difference between jsp and asp.net Crespin Software Development 3 24-11-2009 06:57 AM
Difference between wap and wep Soggy Bottom Networking & Security 3 23-11-2009 09:34 AM
Difference between IDE and ATA LALETTE Hardware Peripherals 3 09-01-2009 10:34 AM


All times are GMT +5.5. The time now is 02:55 AM.