Difference between OLEDB Provider and SqlClient ?

Answers were Sorted based on User's Feedback



Difference between OLEDB Provider and SqlClient ?..

Answer / rajesh

SqlClient namespace is used to connect microsoft sqlserver
database while OLEDB namespace is used to connect older
databases such as ms access and mysql

Is This Answer Correct ?    11 Yes 4 No

Difference between OLEDB Provider and SqlClient ?..

Answer / dhana

sqlclient is exclusively for sqlserver as backend while
oledb is for access,sqlserver,oracle

using sqlclient provides extra functions while using
sqlserver as backend

Is This Answer Correct ?    10 Yes 8 No

Post New Answer

More ADO.NET Interview Questions

What is the difference between linq and ado.net?

0 Answers  


WHAT Are the major major compnents of a data provider in ADO.net.

14 Answers   Infosys, Wipro,


Difference between ADO and ADO.net ?

11 Answers   Accenture, BirlaSoft, College School Exams Tests, Krest, Red Apple,


how Sequence to connect and retrieve data from database using dataset?

0 Answers  


What does executequery return?

0 Answers  






What is the role of the dataset object in ado.net?

0 Answers  


How to bind the controls(best practice) comboboxes to the data in the dataset?

0 Answers  


What is the difference between sqldatareader and sqldataadapter?

0 Answers  


What are the differences between OLEDB and SQLClient Providers?

0 Answers  


Describe briefly an ADO.NET Dataset ?

0 Answers   Siebel,


What is the difference between data reader and data adapter?

0 Answers  


what is clustered index?why is it created?

4 Answers   Microsoft, Wipro,


Categories