8.23.2012

Difference between OLEDB Provider and SqlClient

S.No
OLEDB Provider
SqlClient
1
OLEDB Provider is slower than SqlClient data provider
The SqlClient data provider is faster than the Oracle provider, and even more faster than accessing database through the OLEDB layer.

Reason for being faster is, it access the native library which generally gives us a better performance and it has also got a lot of support from SQL Server team online.

No comments:

Post a Comment