Interview answers verified by specialists.

Find interview questions and answers on this website:

See right interview answers on 30 common job interview questions

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.

Do you know that?

Elance receives half a million visitors a week. That's more than the Great Wall of China and Notre Dame de Paris combined Next