Home > DeveloperSection > Interviews > What is the role of data provider?

Posted on    October-26-2010 12:00 AM

 ADO.Net ADO.Net 
 1 Answer(s)
  2160  View(s)
Rate this:

hanmandlu vasani

Total Post:30

Posted on    April-16-2014 12:00 AM

The .NET data provider layer resides between the application and the database. Its task is to take care of all their interactions.

The .NET Data provider can be demonstrated to be:

SQL Server data provider
OLEDB data provider
ODBC Data Provider

ADO.NET supports the following OLE DB Providers:

- SQLOLEDB - Microsoft OLE DB Provider for SQL Server.
- MSDAORA - Microsoft OLE DB Provider for Oracle.
- Microsoft.Jet.OLEDB.4.0 - OLE DB Provider for Microsoft Jet.

Don't want to miss updates? Please click the below button!

Follow MindStick