Differences between ADO and ADO. NET

Overview

ADO and ADO. NET are two data access methods. ADO. NET uses the offline method. when accessing data, ADO. NET uses XML to make a copy of the data. The database connection of ADO. NET must be online during this time. While ADO uses the COM technology, this requires that the data type used must comply with the COM specification, while ADO. NET is based on the XML format, and the data types are more abundant and do not need to be converted due to the COM orchestration, thus improving the overall performance.

Architecture chart

Detail comparison

ADO	ADO. NET
Data is stored as A Recordset	Data is stored as Dataset
Data in Recordset comes from multiple Table, which is displayed in one table.	Dataset saves each table Stored as a separate entity of a datatable object
Perform sequential processing in the table	Control can be transferred from one row of the table to another.
Easy access to databases	Provides intermittent access to the database
The data type must be converted to COM first. Data Type before you can Inter-Transmission	Dataset is transmitted in XML format

Summary

ADO. NET provides an Optimized Data Access Model for the. NET architecture. It is similar to the COM-based ADO. It is also because ADO. NET is based on the XML format that the data type is richer and does not need to be converted due to the COM orchestration, thus improving the overall performance.