Software Code Help - How many type of Data Provider in ADO.NET

Thursday, July 02, 2009

How many type of Data Provider in ADO.NET by Raj Shekhar

A data provider is a set of ADO.NET classes that allows you to access a specific database, execute SQL commands, and retrieve data. Essentially, a data provider is a bridge between your application and a data source.

There are four type of providers in .net:

• SQL Server provider: Provides optimized access to a SQL Server database (version 7.0 or later).

• OLE DB provider: Provides access to any data source that has an OLE DB driver. This includes SQL Server databases prior to version 7.0.

• Oracle provider: Provides optimized access to an Oracle database (version 8i or later).

• ODBC provider: Provides access to any data source that has an ODBC driver.

Thursday, July 02, 2009 12:02:02 PM (GMT Daylight Time, UTC+01:00)

Comments [0] Interview Question ADO.NET |

Comments are closed.