Differences between ADO and ADO.NET

Differences between ADO and ADO.NET

The Major Differences between ADO and ADO.NET is that ADO is a COM-based Library and ADO.net is a CLR based Library.

Comparison Chart

ADOADO.Net
It is a COM(Component Object Modelling) based Library.It is a CLR(Common Language Runtime) based Library.
ADO works in the connected mode to access data.ADO.Net works in the disconnected mode to access data.
Locking features is available.Locking features is not available.
Data is stored in Binary Format.Data is stored in XML.
XML integration is not possible.XML integration is possible.
It uses RecordSet to store the data from data source.It uses Dataset to store the data from data source.
Using classic ADO, you can obtain information from one table or set of tables through the join. You cannot fetch records from multiple tables independently.Dataset object of ADO.Net includes a collection of DataTable wherein each DataTable will contain records fetched from a particular table. Hence multiple table records are maintained independently.
In ADO, You can create only a Client-side cursor.In ADO.Net, you can create both Client & Server-side cursor.
Derives information about data implicitly at run time, based on metadata that is often expensive to obtain.Leverages known metadata at design time in order to provide better run-time performance and more consistent run-time behavior.
A firewall might prevent execution of Classic ADO.ADO.Net has firewall proof and its execution will never be interrupted.
You cannot send multiple transactions using a single connection instance.You can send multiple transactions using a single connection instance.

ADO

  • It is a COM-based library.
  • Classic ADO requires an active connection with the data store.
  • The locking feature is available.
  • Data is stored in binary format.XML integration is not possible.
  • It uses the object named Recordset to reference data from the data store.
  • Using Classic ADO, we can obtain information from one table or set of tables through the join. We cannot fetch records from multiple tables independently.
  • A firewall might prevent the execution of Classic ADO.
  • Classic ADO architecture includes client side cursor and server side cursor.
  • We cannot send multiple transactions using a single connection instance.

ADO.NET

  • ADO stands for ActiveX Data Objects
  • ADO.NET is a database technology of .NET Framework used to connect the application system and database server.
  • ADO.NET is a part of the .NET Framework
  • ADO.NET consists of a set of classes used to handle data access
  • ADO.NET uses XML to store and transfer data among applications, which is not only an industry-standard but also provide fast access to data for desktop and distributed applications.
  • ADO.NET is scalable and interoperable.

Related Difference

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here