Data providers in .NET Framework

Question

Mention different types of data providers available in .NET Framework.

Answer 1

a) .NET Framework Data Provider for SQL Server - It offers access to the Microsoft SQL Server 7.0 or later version. It uses the System.Data.SqlClient namespace.

b) .NET Framework Data Provider for ODBC - It provides access to the databases exposed by using ODBC. It uses the System.Data.Odbc namespace.

c) .NET Framework Data Provider for OLE DB - It provides access to databases exposed by using OLE DB. It uses the System.Data.OleDb namespace.

d) .NET Framework Data Provider for Oracle - It provides access to the Oracle database 8.1.7 or later versions. It uses the System.Data.OracleClient namespace.