Difference between OLEDB Provider and SqlClient ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an ado?

514


What is serialization and de-serialization in .net?

489


Which is faster dataset or datareader?

519


What does ole stand for in excel?

596


Explain ado.net features?

530






Give an example of a .net application which connects to microsoft access database using ado.net classes.

582


What is ado.net tutorial?

498


What do you mean by performing asynchronous operation using command object?

507


How will you fill the gridview by using datatable object at runtime?

546


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

527


Define Execute Reader?

586


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

520


Explain the difference between ado and ado.net?

500


How to retrieve the user id which is provided while windows authentication?

586


If a table contains 20000 records. In a page at each time 100 records to be displayed.

511