Home > DeveloperSection > Interviews > What is the difference between OLEDB Provider and SqlClient?

Posted on    August-21-2014 11:37 PM

 ADO.Net ADO.Net 
 1 Answer(s)
  1245  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Posted on    August-21-2014 12:00 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick