ARCHITECTURE OF ADO.NET
ADO.NET
Ø 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
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
access code.
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
the
·
Microsoft SQL Server Data Provider ,
·
OLEDB Data Provider
·
ODBC Data Provider .
Ø SQL
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
·
Connection Object,
·
Command Object ,
·
DataReader Object
·
DataAdapter Object.
Ø The
Connection Object provides physical connection to the Data Source.
Ø The
Command Object uses to perform SQL statement or stored procedure to be executed
at the Data Source.
Ø 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.
Ø Finally
the DataAdapter Object , which populate a Dataset Object with results from a
Data Source .
·
C# Connection
·
C# Command
·
C# DataReader
·
C# DataAdapter
·
DataSet
Ø DataSet
provides a disconnected representation of result sets from the Data Source, and
it is completely independent from the Data Source.
Ø DataSet
provides much greater flexibility when dealing with related Result Sets.
Ø DataSet
consists of a collection of DataTable objects that you can relate to each other
with DataRelation objects.
Ø The
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.
Related Topics
Privacy Policy, Terms and Conditions, DMCA Policy and Compliant
Copyright © 2018-2024 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.