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

Question

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

Satyapriya Nayak · Answer

Hi Arun ADO : ADO is created using COM Technology.(COM stands for component object model) In ADO we can store only one table. In ADO we can't generate relations. In ADO we can't generate sql statements. ADO is connection-Oriented. ADO.Net : ADO.Net is implemented by using .Net Framework technology. ADO.Net we can store multiple tables in the DataSet. In ADO.Net we can generate relations. In ADO.Net we can generate sql statements. ADO.Net is connection less. Please refer the below link http://sachin-csharp.blogspot.in/2012/01/what-is-difference-between-ado-and.html http://dotnetguts.blogspot.in/2007/07/difference-between-ado-and-adonet.html Thanks

Harvey Devakumar · Answer

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.

Sivaraman Dhamodaran · Answer

ADO stands for ActiveX Data Objects. They are used to connect to database and do varieties of db tasks on vb 6.0 days. Once Dot net frame work is released we got ADO.NET. There are lot of differences and ado.net is the enhanced one. A Major difference is you can work disconnected in the ADO.Net. That means connect to db get data go disconnected Work on cached data push back the changed stuff.