Difference between OLEDB Provider and SqlClient

Question

What is the Difference between OLEDB Provider and SqlClient.

Satyapriya Nayak · Answer

Hi Sharad .NET Framework Data Provider for OLE DB is universal for accessing other sources like Oracle DB2 Microsoft Access and Informix but it's a .NET layer on top of OLEDB layer Performance is not so faster. .NET Framework Data Provider for SQL Server is used only for sql server database is high-speed and robust.Performance is faster. .NET Framework Data Provider for Oracle is used only for Oracle database is high-speed and robust.Performance is faster. Refer http://msdn.microsoft.com/en-us/library/a6cd7c08.aspx Thanks

Kunal Vaishya · Answer

OLEDB Provider use to connect Access  Excel etc and SqlClient use to connect with SqlServer or SqlData File