ADO.NET Classes:

 Connection:

-> Maintains the connection with the database.

 Command:

-> Executes a Query Statement( Select Statement), Non-Query Statement(insert /update/delete) or stored procedure/function at back-end.

DataReader:

->It acts as a buffer, which holds the data, after execution of a query statement at back-end.

DataAdapter:

-> Executes a query statement at back-end.

Parameter:

-> Sends a parameter (argument) value to a back-end stored procedure/function.

Dataset:

->Acts as a buffer which holds multiple tables at a time.

DataTable:

->Acts as a buffer, which holds a single table (collection of rows and columns)

DataRow:

->Acts as a buffer, which holds a single row.

DataColumn:

Acts as a buffer, which holds single column.

Note:

All the above classes needs to create Objects of these classes.