Data Providers In ADO.NET

1. Connection Object :- It provides a connection to the database
 2. Command Object :- It is used to execute a command
3. DataReader Object :- It provides a forward-only, read only, connected RecordSet
4. DataAdapter Object :- It populates a disconnected DataSet with data and performs update
These all above ADO.NET Objects consists of following major component class based on their data providers:
1. Sql Data Provider :-

•  SqlConnection - Connection Object
•  SqlCommand - Command Object
•  SqlDataReader - DataReader Object
•  SqlDataAdapter - DataAdapter Object

2. OleDb Data Provider :-

•  OledbConnection - Connection Object
•  OledbCommand - Command Object
•  OledbDataReader - DataReader Object
•  OledbDataAdapter - DataAdapter Object

3. Odbc Data Provider :-

•  OdbcConnection - Connection Object
•  OdbcCommand - Command Object
•  OdbcDataReader - DataReader Object
•  OdbcDataAdapter - DataAdapter Object

4. Oracle Data Provider :-

•  OracleConnection - Connection Object
•  OracleCommand - Command Object
•  OracleDataReader - DataReader Object
•  OracleDataAdapter - DataAdapter Object

These all above component classes found into their namespaces based on Data Provider.

•  Sql Data Provider Component Classes found in the System.Data.SqlClient namespace
•  Oledb Data Provider Component Classes found in the System.Data.Oledb namespace
•  Odbc Data Provider Componenet Classes found in the System.Data.Odbc namespace
•  Oracle Data Provider Component Classes found in the System.Data.OracleClient namespace

ADO.NET Architecture: