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 difference between datagridview and datagrid control in winforms?

522


Explain the architecture of ado.net?

549


Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

628


What is ado.net components?

515


What is the difference between Optimistic and Pessimistic locking?

553






How is entity framework different from ado.net?

494


How do you implement locking concept for dataset?

549


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

589


What are different layers of ADO.Net?

596


What is a dataview?

539


What is the full form of ado?

518


What is difference between ado and other data object?

477


Describe connection object in ado.net

547


Describe datareader object of ado.net with example.

520


Define data adapter?

516