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 a Class in dot Net? The class describes all the attributes of objects, as well as the methods which implement the behavior of member objects. It is a comprehensive data

Need to develop a simple .net software I am seeking someone who can design a customized software for me, prefrebly in .NET. I have a sql server backend which i would like to use

Howto create a simple stylesheet for a web application

What is Array List? An Array is whose size can increase or decrease dynamically. The Array list can hold item of various types. As Array list can increase and decrease his size

I need Windows Phone App (WP 8 and above) I am seeking an app developer/designer to develop me a Windows Phone app. This will be an app where users will post questions in the

What is LOCK escalation? The Lock escalation is the process of converting of the low level locks (such as row locks, page locks) into the higher level locks (such as table lock

What are the best practices while implementing globalization and localization? The best methods while developing international language support software are shown below:- 1)

How can you increase SQL performance? 1)Keep your indexes as narrow as possible. This reduces the size of the index and decrease the number of reads needed to read the index.

Project Description: We are seeking a simple tool that can convert an existing flash file (.SWF) into HTML5. Our idea is to convert small flash games into html5 games. Please NO

What is impersonation in ASP.NET? By default, the ASP.NET executes in the security context of a restricted user account on the local machine. Sometimes you require to access ne