ADO.net Components

ADO.net Components has two main components:
1. .net framework data providers
2. The dataset

1. .net framework data providers:
Components that have been explicitly designed for data manipulation
Provides fast-forward only, read only access to data
Connection object: Provides connectivity to a data source
Command object: Enables access to database commands
DataReader object: Provides a high-performance stream of data
DataAdapter: Provides the bridge between the dataset and data source
Uses command object to execute SQL commands at the data source to load the dataset with data and also to synch the changes

.net framework has following data providers serving various database products
SQL Server: System.Data.SqlClient
OLE DB: System.Data.OleDB
ODBC: System.Data.ODBC
Oracle: System.Data.OracleClient (ver. 8.1.7 or later )