Explain the architecture of ado.net in brief, DOT NET Programming

Assignment Help:

Explain the architecture of ADO.NET in brief.

AD0.NET having of two fundamental components:

The DataSet, which is disconnected from the data source and does not require to know where the data that it holds is retrieved from.

The .net data provider, which permits you to connect your application to the data source and execute the SQL commands against it.

The data provider has the Connection, Command, DataReader, and DataAdapter objects. The Connection object gives connectivity to the database. The Command object gives access to database commands to retrieve and manipulate data in a database. The DataReader object retrieves data from the database in the readonly and forward-only mode. The DataAdapter object uses Command objects to implement SQL commands. The DataAdapter object loads the DataSet object with data and also updates alters that you have made to the data in the DataSet object back to the database.

 


Related Discussions:- Explain the architecture of ado.net in brief

What is common language specification, What is Common Language Specificatio...

What is Common Language Specification (CLS)? CLS is a set of essential rules, which must be followed by each .NET language to be a .NET- compliant language. It enables interope

Capstone .., Why isn''t there an allowed amount for nonfacility for code 27...

Why isn''t there an allowed amount for nonfacility for code 27405?

How to increase sql performance?, How can you increase SQL performance? ...

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.

Website programming , Question 1 A small Canadian law firm specializin...

Question 1 A small Canadian law firm specializing in immigration law has what it considers a successful website. One of the most popular features of the website is its newslet

Website builder must be a desktop application, As its name suggests, the we...

As its name suggests, the website builder must be a desktop application that will allow users to simply create websites. Essentially, the program will have to give the users with a

Creation of a dynamic corporate web site, wiConstellation WEB site Proje...

wiConstellation WEB site Project Description: Creation of a dynamic corporate WEB site with administration panel, requirement collaboration, product definition, Q&A, user man

Candidate key, What is a candidate key? A table may have more than one ...

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 have a website with a photo gallery, I have a website with a photo galler...

I have a website with a photo gallery using PhotoHandler -photohandler.codeplex.com I require the code added/ modified to display the image file names under the preview or thumbnai

I need .net application decompile, I need .NET Application Decompile Pro...

I need .NET Application Decompile Project Description: We have a minute .net utility which we want to decompile back into .net project. .Net application can be made availa

Appsetting section in "web.config" file, What is AppSetting Section in "Web...

What is AppSetting Section in "Web.Config" file? Web.config file describe the configuration for a webproject. By Using "AppSetting" section we can define user defined values. T

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd