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 ado net stands for?

0 Answers  


What are the types of databinding?

0 Answers  


What is DataRowCollection?

0 Answers  


What is the difference between DataReader and DataSet in ADO.NET?

0 Answers   Petranics Solutions,


What do you know about ADO.NET's objects and methods?

0 Answers   NA,


What is two way data binding android?

0 Answers  


WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE

2 Answers  


What are the three Objects of ADO.

10 Answers  


What is variable view?

0 Answers  


Give an example that shows how to execute a stored procedure in ado.net?

0 Answers  


Can we connect two dataadapters to same data source using single connection at same time?

0 Answers  


How to read data with the sqldatareader ?

0 Answers  


Categories