Difference between OLEDB Provider and SqlClient
What is the Difference between OLEDB Provider and SqlClient.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Oct 10, 2012, 7:20 AM
.NET Framework Data Provider for OLE DB is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix, but it's a .NET layer on top of OLEDB layer, Performance is not so faster.
.NET Framework Data Provider for SQL Server is used only for sql server database is high-speed and robust.Performance is faster.
.NET Framework Data Provider for Oracle is used only for Oracle database is high-speed and robust.Performance is faster.
Refer
http://msdn.microsoft.com/en-us/library/a6cd7c08.aspx
Thanks
Kunal VaishyaPosted Oct 10, 2012, 6:58 AM