Ado.net architecture, DOT NET Programming

Can you give an overview of ADO.NET architecture?

The most important part  in the ADO.NET architecture is the "Data Provider". The  Data Provider provides access to the datasource ( ACCESS, ORACLE, SQL SERVER).In brief  it gives the object to achieve functionalities such as  opening and closing connection, update data and retrieve data . In the below shown figure you can see the 4 main parts of a data provider :-

  • Connection.
  • Command object (This is the responsible object to use the stored procedures).
  • Data Adapter (This object acts as a bridge between the datastore and the dataset).
  • Datareader (This object reads data from the data store in only the forward  mode).

The Dataset object shows the disconnected and cached data. If you see the diagram it is not in the direct connection with the data store (ORACLE, SQL SERVER etc) rather it talks with the Data adapter, who is responsible for filling the dataset.  The Dataset can have one or more Data table and relations.

831_ADO.net architecture.png

Posted Date: 9/24/2012 2:18:32 AM | Location : United States







Related Discussions:- Ado.net architecture, Assignment Help, Ask Question on Ado.net architecture, Get Answer, Expert's Help, Ado.net architecture Discussions

Write discussion on Ado.net architecture
Your posts are moderated
Related Questions
What is project management? Applying the knowledge, skills, techniques, tools in project and deliver project deliverable is a short definition of the project management. It's b

Name the two properties of the GridView control that have to be specified to turn on sorting and paging. The properties of the GridView control that require to be specified to

What is a candidate key? A table may have more than one combination of columns that could uniquely identify the rows in a table; every combination is a candidate key. During th

I need help in Calendar integration into site using .net I'm demanding to create a web-based proof of concept for the following scenario. I'd like to permit a user to select

Project Description: I have various C# support projects and no time, so I'm seeking for a junior programmer to help out. This intro project is a C# module to develop the UI a

How to implement DTC in .NET DTC is implemented using the COM+. Following are some of the steps to implement COM + in .NET:- 1) The "EnterpriseService" namespace has all

Project Description: I am having a table available in excel format and features the subsequent: - It has about 170000 rows - Some text is longer than 255 in length. - S

Project Description: I need complete school management software, where user will get four module for their enquiry, 1> Student management 2> Staff complete payrole system

I need C# AAC sound receiver over WCF Project Description: I want a WCF method which is able to receive a byte stream of an AAC sound file from iPhone device and save it on t

Project Description: Overview: Prepare Windows program that runs in the background and on start up on the client's computer that grabs CERTAIN data from a.SDF file (SQL Serve