OLEDB Provider and SqlClient

Question

Write about the difference between OLEDB Provider and the SqlClient?

Answer 1

Regarding usage, there exists no difference between the OLEDB Provider and SqlClient. The dissimilarity lies in their performance. SqlClient is explicitly used in order to connect your application to the SQL server directly, OLEDB provider is generic for several databases, like Oracle and Access comprising SQL Server.

Thus, there will be an overhead that may leads to degradation of the performance.