The Data Provider is a one of the major components of ADO.NET architecture, it is responsible for providing and maintaining the connection to the database. A DataProvider is a collection of related components that work together to provide data in an efficient manner.
Currently, the following data providers are available in .NET Framework,
- SQL Server
Each DataProvider consists of the following component classes:
The Connection object which provides a connection to the database
The Command object which is used to execute a command
The DataReader object which provides a forward-only, read only, connected recordset
The DataAdapter object which populates a disconnected DataSet with data and performs update