Different between ado and ado.net

Question

Brahma Prakash Shukla · Answer

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

Vishal Yelve · Answer

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 Hawaldar · Answer

https://www.c-sharpcorner.com/interview-question/difference-between-ado-and-adonet