WHAT IS THE DIFFERENCE BETWEEN OLEDB PROVIDER AND SQLCLIENT?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1426  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What is the difference between OLEDB Provider and SqlClient?

    With respect to usage, there is no difference between OLEDB Provider and SqlClient. The difference lies in their performance. SqlClient is explicitly used to connect your application to SQL server directly, OLEDB Provider is generic for various databases, such as Oracle and Access including SQL Server.

    Therefore, there will be an overhead which leads to performance degradation.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!