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
Prepare .NET TWAIN application to control digital imaging sensor Project Description: We are seeking somebody to create a .NET TWAIN application which will activate a digital

Accepting a List of 5 Items - C# Program Hello, I've been trying so many codes for this but those codes didn't work well. Please write the code for Accepting a List of 5 Items

What is a cloud? A cloud is a combination of hardware, storage, networks, services, and interfaces that helps in delivering computing as a service. It has generally three users

What is boxing in .net

Data hiding and encryption would be done on images. Both these process should have a data hiding key and an encryption key correspondingly. Another user should be able to decrypt t

I need a Web Application UI Modernization - Preliminary Technology Assessment We are seeking to overhaul a 10-year old enterprise application, CRM-related as well as web-based t

Are you available to discuss about my project. I'd like you to show first and then accept the project provided if we both agree to continue with each other. Skills required:

I need Windows 8.1 Project, Asset management slate App Project Description: We are seeking a Windows 8 app developer with PROVABLE experience to prepare a project and asset m

How can you provide an alternating color scheme in a Repeater control?  AlternatingItemTemplate Like the ItemTemplate element, but rendered for each other row (alternating item

Project Description: We require.NET ( C#.Net or VB.Net ) application to send whatsapp message : - The application could be connected to SQL server database to fetch the conta