Tuesday, September 29, 2009

Data Provider

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
  • ODBC
  • Oracle

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

No comments:

Post a Comment