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 ole in vb?

0 Answers  


What is data access pattern?

0 Answers  


What is openrowset?

0 Answers  


What is the maximum pool size in ado.net connection string?

0 Answers  


Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

0 Answers  






How do you merge two datasets into the third dataset in a simple manner?

3 Answers   IBM,


How to Handle the exceptions in Sqlsrver2000

3 Answers   SQL Star,


What is difference between sqldatareader and sqldataadapter?

0 Answers  


What is ole db and odbc?

0 Answers  


What is connection string?

0 Answers  


Explain acid properties?

4 Answers  


What is linq and entity framework?

0 Answers  


Categories