Different between ado and ado.net

Head to Head differences	ADO	ADO.NET
1 Data Representation	In ADO, data is represented by a RecordSet object, which can hold data from one data source at a time.	In ADO.NET, data is represented by a DataSet object, which can hold data from various data sources, integrate it, and after combining all the data it can write it back to one or several data sources.
2 Data Reads	In ADO, data is read in sequential manner.	In ADO.NET, data is read either in a sequential or non-sequential manner.
3 Disconnected Access	ADO first makes a call to an OLE DB provider. It supports the connected access, represented by the Connection with a database.	It uses standardized calls such as DataSetCommand object to communicate with a database and with the OLE DB provider.
4 Creating Cursors	It allows us to create client-side cursor only.	ADO.NET either created client-side or server-side cursors.
5 Locking	ADO has the feature of locking.&	This features is not used in ADO.NET.
6 XML integration	This feature is not used in ADO.	This feature is used in ADO.NET.
7 Relationship between Multiple Tables	It requires SQL Join and UNIONs to combine data from multiple tables in a single RecordSet.	It uses DataRelation objects for combining data from multiple tables without the use of SQL Join and UNIONs.
8 Conversion	ADO requires data to be converted to data types supported by receiving system.	ADO.NET does not require complex conversions that wasted processor time.
9 Data Storage	In ADO data is stored in a binary form.	In ADO.NET, data is stored in XML form. With the use of XML, it stores data more easily.
10 Firewalls	In ADO, firewalls are typically configured to prevent system-level requests, such as COM marshaling.	In ADO.NET firewalls are supported because ADO.NET DataSet objects use XML for representing data.
11 Communication	In this, objects are communicate in a binary mode.	It uses XML for communication.
12 Programmability	It uses a Connection object to transfer commands to a data source with defined data constructs.	ADO.NET does not require data constructs because it uses strongly typed characteristics of XML.
13 Connection Model	ADO supports only one model of connection i.e. Connection Oriented Data Access Architecture Model.	ADO.NET supports two models of connection i.e. Connection-Oriented Data Access Architecture and Disconnected Oriented Data Access Architecture.
14. Environment	ADO was geared for a two-tiered architecture.	ADO.NET address a multi-tiered architecture.
15. Metadata	It derives information automatically at runtime based on metadata.	In ADO.NET derives information at design time on metadata in order to provide better runtime performance.
16. Multiple Transactions	In ADO multiple transactions cannot be send using a single connection.	In ADO.NET multiple transactions can be send using a single connection.
17. Data Types	It has a less number of data types.	It has a huge and rich collection of data types.
18. Serialization	ADO serialized data in a proprietary protocol.	ADO.NET serialized data using XML.
19. Security	ADO is less secured.	ADO.NET much secured as compared to ADO.
20 Based on	ADO is based on Component Object Modelling.	ADO.NET is a Common Language Runtime based library.
21 Scalability	ADO technology have less scalable.	ADO.NET have more scalability with the use of locking mechanism.
22. Resources	ADO technology use more resources as compared to ADO.NET.	ADO.NET conserves limited resources.
23. Performance	ADO have a poor performance.	In ADO.NET performance is much better as compared to ADO.

1. ADO :
ADO was introduced in 1996 by Microsoft as its component of MDAC (Microsoft Data Access Components). It is based on COM (Component Object Modelling). ADO with other components of MDAC serves as a framework for client applications to access data stores. It removes necessitate to know implementation of database and lowers complexity of handling low level code requires for dealing with data.

2. ADO.NET :
ADO.NET is an advanced database technology from Microsoft .NET Framework which provides communication between application system and database server. It is a component of the .NET Framework that is designed to work on disconnected model to access data from data store. Some of the .NET applications which are used to connect with database server are ASP.NET web applications, windows applications and console applications

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Yelve3y ago

Head to Head differences	ADO	ADO.NET
1 Data Representation	In ADO, data is represented by a RecordSet object, which can hold data from one data source at a time.	In ADO.NET, data is represented by a DataSet object, which can hold data from various data sources, integrate it, and after combining all the data it can write it back to one or several data sources.
2 Data Reads	In ADO, data is read in sequential manner.	In ADO.NET, data is read either in a sequential or non-sequential manner.
3 Disconnected Access	ADO first makes a call to an OLE DB provider. It supports the connected access, represented by the Connection with a database.	It uses standardized calls such as DataSetCommand object to communicate with a database and with the OLE DB provider.
4 Creating Cursors	It allows us to create client-side cursor only.	ADO.NET either created client-side or server-side cursors.
5 Locking	ADO has the feature of locking.&	This features is not used in ADO.NET.
6 XML integration	This feature is not used in ADO.	This feature is used in ADO.NET.
7 Relationship between Multiple Tables	It requires SQL Join and UNIONs to combine data from multiple tables in a single RecordSet.	It uses DataRelation objects for combining data from multiple tables without the use of SQL Join and UNIONs.
8 Conversion	ADO requires data to be converted to data types supported by receiving system.	ADO.NET does not require complex conversions that wasted processor time.
9 Data Storage	In ADO data is stored in a binary form.	In ADO.NET, data is stored in XML form. With the use of XML, it stores data more easily.
10 Firewalls	In ADO, firewalls are typically configured to prevent system-level requests, such as COM marshaling.	In ADO.NET firewalls are supported because ADO.NET DataSet objects use XML for representing data.
11 Communication	In this, objects are communicate in a binary mode.	It uses XML for communication.
12 Programmability	It uses a Connection object to transfer commands to a data source with defined data constructs.	ADO.NET does not require data constructs because it uses strongly typed characteristics of XML.
13 Connection Model	ADO supports only one model of connection i.e. Connection Oriented Data Access Architecture Model.	ADO.NET supports two models of connection i.e. Connection-Oriented Data Access Architecture and Disconnected Oriented Data Access Architecture.
14. Environment	ADO was geared for a two-tiered architecture.	ADO.NET address a multi-tiered architecture.
15. Metadata	It derives information automatically at runtime based on metadata.	In ADO.NET derives information at design time on metadata in order to provide better runtime performance.
16. Multiple Transactions	In ADO multiple transactions cannot be send using a single connection.	In ADO.NET multiple transactions can be send using a single connection.
17. Data Types	It has a less number of data types.	It has a huge and rich collection of data types.
18. Serialization	ADO serialized data in a proprietary protocol.	ADO.NET serialized data using XML.
19. Security	ADO is less secured.	ADO.NET much secured as compared to ADO.
20 Based on	ADO is based on Component Object Modelling.	ADO.NET is a Common Language Runtime based library.
21 Scalability	ADO technology have less scalable.	ADO.NET have more scalability with the use of locking mechanism.
22. Resources	ADO technology use more resources as compared to ADO.NET.	ADO.NET conserves limited resources.
23. Performance	ADO have a poor performance.	In ADO.NET performance is much better as compared to ADO.

Rajanikant Hawaldar3y ago
https://www.c-sharpcorner.com/interview-question/difference-between-ado-and-adonet
+3
Brahma Prakash Shukla3y ago
1. ADO :
ADO was introduced in 1996 by Microsoft as its component of MDAC (Microsoft Data Access Components). It is based on COM (Component Object Modelling). ADO with other components of MDAC serves as a framework for client applications to access data stores. It removes necessitate to know implementation of database and lowers complexity of handling low level code requires for dealing with data.

2. ADO.NET :
ADO.NET is an advanced database technology from Microsoft .NET Framework which provides communication between application system and database server. It is a component of the .NET Framework that is designed to work on disconnected model to access data from data store. Some of the .NET applications which are used to connect with database server are ASP.NET web applications, windows applications and console applications
+3