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. architecture.png

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

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

Write discussion on architecture
Your posts are moderated
Related Questions
What are the precautions so that StateServer Mode work properly? Following are some points to remember so that StateServer Mode works properly:- a) StateServer mode session

What is the difference between Server.Transfer and response.Redirect? The difference  between the Server.Transfer and the response.Redirect them are as follows:- 1)Response.

What is the purpose of DOTNET? Dot Net Is a collection of products like C#, ASp.Net, Vb.Net, XML. The purpose of .Net is that we can simply upgrade and degrade our programs whi

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

Find out circumference and area of a circle - C# Program Need Help in Assignment.

What is the difference between dynamic and var data types? The difference among the var and dynamic data types is that the var data type is strongly type checked at the compile

How many types of diagrams are there in UML? There are nine types of diagrams in the UML as shown below:- 1)Use case diagram: The use case diagram describe "WHAT" of a

What is the use of the Connection object? The Connection object is used to connect your application to a specific data source by giving the needed authentication information in