Explain the Architecture of ADO. Net

1 year ago
Cloud Computing



                                                    Fig:- asp.net-ado.net-architecture

ADO.NET consists of a set of Objects that expose data access services to the .NET environment. It is a data access technology from Microsoft .Net Framework, which provides communication between relational and non-relational systems through a common set of components.

System.The data namespace is the core of ADO.NET and it contains classes used by all data providers. ADO.NET is designed to be easy to use, and Visual Studio provides several wizards and other features that you can use to generate ADO.NET data access code.

Data Providers and DataSet




The two key components of ADO.NET are Data Providers and DataSet. The Data Provider classes are meant to work with different kinds of data sources. They are used to perform all data-management operations on specific databases. The DataSet class provides mechanisms for managing data when it is disconnected from the data source.


                                                            Fig:- Data Providers


The .Net Framework includes mainly three Data Providers for ADO.NET. They are the Microsoft SQL Server Data Provider , OLEDB Data Provider and ODBC Data Provider . SQL Server uses the SqlConnection object , OLEDB uses the OleDbConnection Object and ODBC uses OdbcConnection Object respectively.

A data provider contains Connection, Command, DataAdapter, and DataReader objects. These four objects provides the functionality of Data Providers in the ADO.NET.


The Connection Object provides physical connection to the Data Source. Connection object needs the necessary information to recognize the data source and to log on to it properly, this information is provided through a connection string.

ASP.NET Connection Command

The Command Object uses to perform SQL statement or stored procedure to be executed at the Data Source. The command object provides a number of Execute methods that can be used to perform the SQL queries in a variety of fashions.

ASP.NET Command DataReader

The DataReader Object is a stream-based , forward-only, read-only retrieval of query results from the Data Source, which do not update the data. DataReader requires a live connection with the databse and provides a very intelligent way of consuming all or part of the result set.

ASP.NET DataReader DataAdapter

DataAdapter Object populates a Dataset Object with results from a Data Source. It is a special class whose purpose is to bridge the gap between the disconnected Dataset objects and the physical data source.

ASP.NET DataAdapter




DataSet provides a disconnected representation of result sets from the Data Source, and it is completely independent of the Data Source. DataSet provides much greater flexibility when dealing with related Result Sets.

DataSet contains rows, columns, primary keys, constraints, and relations with other DataTable objects. It consists of a collection of DataTable objects that you can relate to each other with DataRelation objects. The DataAdapter Object provides a bridge between the DataSet and the Data Source.



Dipti KC
Dec 19, 2022
More related questions

Questions Bank

View all Questions