Difference between OLEDB Provider and SqlClient ?

Question Posted / guest

2 Answers
11428 Views
I also Faced
E-Mail Answers

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 are the three Objects of ADO.

10 Answers

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

7 Answers

How to insert multiple records in asp .net from Gridview to Sql Database with out using loop condition ?

2 Answers

What is connection string?

0 Answers

What are the different row versions available in table?

0 Answers

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

0 Answers

What does executenonquery () method return?

0 Answers

What is dataset and datatable in ado.net?