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

Which control of the BindingNavigator returns the current position within the data source?

729


What are dcl commands?

505


Define the executescalar method?

511


What is dao and ado?

478


What is difference between executenonquery and executequery?

465






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

559


What are the features of ado.net?

495


What is the meaning of object pooling?

587


What is typed dataset ?

671


What is the use of connection object in ado.net?

560


What is disconnected data?

578


Define data access layer?

528


What is data view and variable view?

479


What is different between sqlcommand object and command behavior object?

534


What is a dataview?

530