.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month

Home >> Forum >> ADO.Net >> Post New QuestionBookmark and Share Subscribe to Forum

Ado.net Architecture

Posted By: Ramesh P     Posted Date: October 29, 2010    Points:2   Category :ADO.Net
Explain about ado.net architecture?

Author: Dhivakaran             
Posted Date: October 29, 2010     Points: 5   

ADO.NET is a collection of classes, interfaces, structures and enumulated types that manages data access from relational data sources with in the .NET framework. These collections are organised into namespaces such as System.Data, System.Data.OLEDB and System.Data.SqlClient.

The ADO.NET components have been designed to separate data access from data manipulation. To accomplish the ADO.NET provides two central components, the DataSet and the .NET DataProvider.

The .NET DataProvider is a set of components that includes the Connection, Command, DataReader and DataAdapter objects. It is used for connecting to a database , executing commands and retrieving results. Using the .NET data provider we can either access database directly or use the disconnected approach. For the disconnected approach we use DataSet class.

Connection Object: It is used to connect to the data source. Data source can be any database file. The connection object contains information like the provider name, server name, datasource name, user name and password.

Command Object: It is used for connect the connection object to a DataReader or DataAdapter object. The command object allow us to execute SQL statement or a stored procedure in a data source.

DataReader Object: It is used to read the data in a fast and efficient manner from the database. It is generally used to extract one or a few records or specific field values or to execute simple SQL statement.

DataAdapter Object: It is used to fill data from the database into the DataSet object. it is use din the disconnected approach.

Dhivakaran T
Author: Ramesh P             
Posted Date: October 29, 2010     Points: 5   

I need also diagram of architecture.




Author: Syed Shakeer Hussain             
Posted Date: October 29, 2010     Points: 5   
Author: duraikannan             
Posted Date: January 22, 2011     Points: 5   

ADO.Net Architecture Diagram

Download Attachment

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend