What is the difference between OLEDB Provider and SqlClient ?

Posted by Bharathi Cherukuri on 4/24/2012 | Category: ADO.NET Interview questions | Views: 4010 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

SQLClient .NET classes are highly optimized for the .net / sqlserver combination and achieve optimal results. The SqlClient data provider is faster than the Oracle provider, and faster than accessing database via the OleDb layer.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is the use of Parameter Object ?

Next > : What is the use of connection object in ado.net ?

Comments or Responses

Posted by: Nareyugam on: 4/25/2012 | Points: 10

Sqlclient is faster then Oledb

More Interview Questions by Bharathi Cherukuri

What is the use of connection object in ado.net ?
What is managed code and unmanaged code ?
What does the parameter Initial Catalog define inside Connection Strin ...
What does the "This window" show in the debugger ?
What is partial class. & what is advantage ?
What does Dispose method do with the connection Object ?
Which debugging window allows you to see the methods called in the ord ...
What connections does Microsoft SQL Server support ?

Latest Interview Questions

What is one thing that you as a developer will never compromise on?
What is metadata?
Difference between Finalize() and Dispose()?
What is Identity?
Is there a way to decrypt stored procedure?
How to get the nth row value of a table.
How to get record of nth row of a table ?
What is sp_config command?
More ...