Home > DeveloperSection > Interviews > Define ADO.Net Architecture in ASP.Net?

Posted on    July-04-2011 2:02 AM

 ASP.Net ASP.Net 
 1 Answer(s)
  2048  View(s)
Rate this:

Arun Singh

Total Post:310

Posted on    July-04-2011 12:00 AM

Data access ADO.Net architecture relies on two component first is Data Provider and Second one is Data Set

  1. DataProvider : The Data Provider is responsible for providing and maintaining the connection to the database. A DataProvider is a set of related components that work together to provide data in an efficient and performance driven manner. Basically there are four classes which are widely used by Data  Provider.
  •  Connection
  •  Command
  •  DataReader
  •  DataAdapter

2.      DataSet:  The dataset is a disconnected, in-memory representation of data. It can be considered as a local copy of the relevant portions of the database. The DataSet is persisted in memory and the data in it can be manipulated and updated independent of the database.

Don't want to miss updates? Please click the below button!

Follow MindStick