ARCHITECTURE OF 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 .
consist of a set of Objects that expose data access services to the .NET
environment. 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
Data Providers and DataSet
Ø The two
key components of ADO.NET are Data Providers and DataSet .
Ø The .Net
Framework includes mainly three Data Providers for ADO.NET.
Ø They are
Microsoft SQL Server Data Provider ,
OLEDB Data Provider
ODBC Data Provider .
Server uses the SqlConnection object , OLEDB uses the OleDbConnection Object
and ODBC uses OdbcConnection Object respectively.
C# SQL Server Connection
C# OLEDB Connection
C# ODBC Connection
Ø The four
Objects from the .Net Framework provides the functionality of Data Providers in
the ADO.NET. They are
Command Object ,
Connection Object provides physical connection to the Data Source.
Command Object uses to perform SQL statement or stored procedure to be executed
at the Data Source.
DataReader Object is a stream-based , forward-only, read-only retrieval of
query results from the Data Source, which do not update the data.
the DataAdapter Object , which populate a Dataset Object with results from a
Data Source .
provides a disconnected representation of result sets from the Data Source, and
it is completely independent from the Data Source.
provides much greater flexibility when dealing with related Result Sets.
consists of a collection of DataTable objects that you can relate to each other
with DataRelation objects.
DataTable contains a collection of DataRow and DataCoulumn Object which
contains Data. The DataAdapter Object provides a bridge between the DataSet and
the Data Source.