Different types of data providers

Question

State different types of data providers existing in .NET Framework?

Answer 1

Different types of data providers existing in .NET Framework are as follows:

i. .NET Framework Data Provider for ODBC – It provides access to the databases exposed by using ODBC. It uses a name System.Data.Odbc.

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

iii. .NET Framework Data Provider for OLE DB - Provides access to databases exposed by using OLE DB. It uses a namespace System.Data.OleDb.

iv. .NET Framework Data Provider for Oracle - Provides access to the Oracle database 8.1.7 or later versions. It uses a namespace System.Data.OracleClient.