Difference between ADO and ADO.NET
Comparison between ADO and ADO.NET
The Major Difference between ADO and ADO.NET is that ADO is a COM-based Library and ADO.net is a CLR based Library.
|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 stores in XML|
|XML integration is not possible||XML integration is possible|
|It uses RecordSet to store the data from datasource||It uses Dataset to store the data from datasource|
|Using classic ADO, you can obtain information from one table or set of tables through join. You cannot fetch records from multiple tables independently||Dataset object of ADO.Net includes 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 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.|
|Firewall might prevent execution of Classic ADO||ADO.Net has firewall proof and its execution will never be interrupted|
|You cannot send multiple transaction using a single connection instance||You can send multiple transaction using a single connection instance|
- 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 a client-side cursor and a server-side cursor.
- We cannot send multiple transactions using a single connection instance.
- 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 provides fast access to data for desktop and distributed applications.
- ADO.NET is scalable and interoperable.