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
What are the parameters that control most of connection pooling behaviors?
Command objects uses, purposes and their methods.
How to identify the updated rows in a dataset?
What is the difference between sqlcommand and sqldataadapter?
What are the steps you will take to improve performance?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What are dataproviders?
What is connected architecture in ado.net?
What are the several execute methods of ado.net?
Is datareader faster than datatable?
What is ado or jdbc?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What is a non query?
What is an orm, and why would you use one instead of plain old ado.net?
What are the namespaces used in ADO.Net to connect to a database?