Difference between OLEDB Provider and SqlClient ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sqldatareader?

677


What is Data view?

784


What is aggregating data ?

709


Which parameter of ConnectionString is used to specify the name of the database?

778


What is ado.net and its features?

730


What is difference between executequery and executeupdate?

703


What are dcl commands?

711


What are the steps you will take to improve performance? Will you use dataset or datareader?

744


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

752


What is the difference between a datareader and a dataset?

708


What is difference between ado and other data object?

670


What does ado stand for?

701


I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

769


What is ado code?

710


What is isolation?

766