What is the difference between OLEDB Provider and SqlClient?
With respect to usage, there is no difference among OLEDB Provider and SqlClient. The dissimilarity lies in their performance. SqlClient is explicitly used to link your application to SQL server directly, OLEDB Provider is generic for a variety of databases, such as Oracle and Access including SQL Server.
Thus, there will be an overhead which leads to performance degradation.