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

Can you explain how to enable and disable connection pooling?

510


What does executenonquery () method return?

504


Define Execute Reader?

598


What is maximum pool size in ado.net connection string?

506


What is difference between sqldatareader and sqldataadapter?

493






differences between ADO and ADO.NET

576


What is ado asp?

521


How we can provide data to ado.net?

551


What is ole in excel?

524


What is the difference between linq and ado.net?

519


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

597


how Sequence to connect and retrieve data from database using dataset?

764


Explain the difference between sqlcommand object and command behavior object?

545


What are the disadvantages of using datalist?

518


Which object holds only data and does not interact with data source?

504