ADO.NET Architecture

ADO.NET is a data access technology from Microsoft .Net Framework , which provides communication between relational and non-relational systems through a common set of components . ADO.NET was built for a disconnected architecture , so it enables truly disconnected data access and data manipulation through its Dataset Object, which is completely independent from the Data Source.
ado.net-architecture.JPG

The two key components of ADO.NET are Data Providers and DataSet . The .Net Framework includes mainly three Data Providers for ADO.NET. The Microsoft SQL Server , OLEDB and ODBC are the main Data Providers in the .Net Framework. In the following pages you can see each component of ADO.NET in details with source code.




The following diagrams show the basic ADO.NET component architecture. The diagram on the left shows the Data Provider classes:

Command, Connection, DataAdapter, and DataReader. These classes provide bridges between .NET applications and data sources. The diagram on the right shows the DataSet class hierarchy. These classes create the .NET application's representation of a set of data.