What are the differnt type of data providers for Dotnet

(1).NET Framework Data Provider for SQL Server
Provides data access for Microsoft SQL Server. Uses the System.Data.SqlClient namespace.
(2).NET Framework Data Provider for OLE DB
For data sources exposed by using OLE DB. Uses the System.Data.OleDb namespace.
(3).NET Framework Data Provider for ODBC
For data sources exposed by using ODBC. Uses the System.Data.Odbc namespace.
(4).NET Framework Data Provider for Oracle
For Oracle data sources. The .NET Framework Data Provider for Oracle supports Oracle client software version 8.1.7 and later, and uses the System.Data.OracleClient namespace.
(5)EntityClient Provider
Provides data access for Entity Data Model (EDM) applications. Uses the System.Data.EntityClient namespace.
(6).NET Framework Data Provider for SQL Server Compact 4.0.
Provides data access for Microsoft SQL Server Compact 4.0. Uses the System.Data.SqlServerCe namespace.

Thanks & Regards,
Chayan Upadhyay

Rajeshk, if this helps please login to Mark As Answer. | Alert Moderator

hi Chayanupadhyay Thank you for the Response,but
wich is the most preferable provider for .net and why?

Thanks&Regards
rajeshkommireddy@gmail.com

Rajeshk, if this helps please login to Mark As Answer. | Alert Moderator

Hi Rajeshk

it depends which database you are using mostly with .net we use sql server so most frequently we use SQL Data provider..
and if you are using any other database then ODBC is best one to connect.
and for Oracle there is one data provider so u can connect oracle by that.

Thanks & Regards,
Chayan Upadhyay

Rajeshk, if this helps please login to Mark As Answer. | Alert Moderator