Do you know that? Having great customer service goes a long way. next

Overview of ADO.NET architecture.

Data Provider provides objects through which functionalities like opening and closing connection, retrieving and updating data can be availed.

It also provides access to data source like SQL Server, Access, and Oracle).

Some of the data provider objects are:

  • Command object which is used to store   procedures. 
  • Data Adapter which is a bridge between   datastore and dataset. 
  • Datareader which reads data from data   store in forward only mode. 
  • A dataset object is not in directly   connected to any data store. It represents disconnected and cached   data. The dataset communicates with Data adapter that fills up the   dataset. Dataset can have one or more Datatable and   relations. 
  • DataView object is used to sort and filter data in   Datatable.