Difference between OLEDB Provider and SqlClient ?

 Posted by Babu_akkandi on 4/8/2009 | Category: ADO.NET Interview questions | Views: 10914
Answer:

SQLClient .NET classes are highly optimized for the .net / sqlserver combination and achieve optimal results. The SqlClient data provider is fast. It's faster than the Oracle provider, and faster than accessing database via the OleDb layer. It's faster because it accesses the native library (which automatically gives you better performance), and it was written with lots of help from the SQL Server team.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response