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 semantic gap? Defining a useful channel includes both understanding the applications requirements and recognizing the limitations of the underlying technology. The gap

What are resource files? The Resource files are the files which contain program resources. Many programmers think that resource files are used only for storing strings. But you

A few changes to OutloProject Description: We require someone who is familiar with programming plug-in to work with Microsoft Outlook. Initially we just require a simple chan

What is object-oriented programming (OOP)? OOP is a method to develop logical modules, such as classes that contain properties, methods, fields, and events. An object is formed

Google Calendar Project Description: I require to syn my Microsoft exchange calendar with the Google calendar so i will view the all the changes that happen in Microsoft exch

Converting Rs. to Paisa - C# Program Need the code of C# Program for Converting Rs. to Paisa.

I need .net expert help for Advance Project First let me start by saying that I have been writing code for almost 25 years. Therefore I am only looking for someone to aid advanc

WP7 get data from public API with XML or JSON Project Description: Hello, I'm seeking someone who knows his way around using an API with XML or JSON output in a windows phone

I want a C# Windows App Project Description: Windows App written in C# that can: Check for Internet connection Load dynamic web site If Internet connection drops rec

Full time contractual programming position (mostly scraping, databasing) Project Description: This is a full time contractual role needed for a sports advisory service. We ar