Data access ADO.Net architecture relies on two component first is Data Provider and Second one is Data Set
- 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.
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.