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.
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
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.