ADO.Net Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 2048 Page Views: 

What do you mean by Data Providers?



Posted By: Avi Date: 30 September 2009 03:59:34 AM
 Answer:

ADO.Net relies on Data Providers to provide access to a particular data source. Each Data Provider exposes a set of objects that we use to manage connections, retrieve data, and update data.

Following are the main objects exposed by each Data Provider:

1) Connection:
This object represents a connection to the database.

2) Command:
This object represents an SQL statement that is executed while connected to the database.

3) DataAdapter:
This object is used to channel data to and from a DataSet object and the underlying data source.

4) DataReader:
This object is used to retrieve a read-only, forward-only stream of data from a database.


Posted By: eTechPlanet


Date: 30 September 2009 03:59:34 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image r988Lv
Related Questions
ADO.Net : How do you use LINQ to SQL?

How do you use LINQ to SQL?

DataContext db = new DataContext(“connection string”); Table<Orders> Orders = db.GetTable<O....
Category: ADO.Net Date: 10/13/2010 2:34:47 PM
ADO.Net : What is strongly typed data context?

What is strongly typed data context?

Strongly typed data context declares all Table collections as members of the context so you don’t ne....
Category: ADO.Net Date: 10/13/2010 12:07:48 PM
ADO.Net : How do you use LINQ to SQL?

How do you use LINQ to SQL?

DataContext db = new DataContext(“connection string”); Table<Customer> Customers = db.GetTable....
Category: ADO.Net Date: 10/13/2010 12:07:48 PM
ADO.Net : How do you load xml to Xelement object?

How do you load xml to Xelement object?

XElement root = XElement.Load(path to xml)
Category: ADO.Net Date: 10/13/2010 11:57:47 AM
ADO.Net : How do you protect your code against SqlInjection attacks?

How do you protect your code against SqlInjection attacks?

Use command parameters for sql query
Category: ADO.Net Date: 10/13/2010 11:57:47 AM