1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

Difference between OLEDB Provider and SqlClient ?

Question Posted / guest

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

Can we bind one datareader wid two dropdown list?

5 Answers  

Why is it important to close an ado.net application?

0 Answers  

What is the hierarchy of data in databases?

0 Answers  

What is ado circle?

0 Answers  

Using Ado.net, what front ends and back ends can you use?

10 Answers  




If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers  

can we create synonymn in ms access,sql server,my sql if so explain me with example

0 Answers  

List all the steps in order, to access a database through ado.net?

0 Answers  

What is the advantage of ado.net?

0 Answers  

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

0 Answers  

Difference between sqlcommand and sqlcommandbuilder?

0 Answers  

How do you sort the data in datagrid?

4 Answers   Choice Solutions,

For more ADO.NET Interview Questions Click Here
Categories