Difference between OLEDB Provider and SqlClient ?
Answers were Sorted based on User's Feedback
Answer / rajesh
SqlClient namespace is used to connect microsoft sqlserver
database while OLEDB namespace is used to connect older
databases such as ms access and mysql
Is This Answer Correct ? | 11 Yes | 4 No |
Answer / 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 |
What is the difference between linq and ado.net?
WHAT Are the major major compnents of a data provider in ADO.net.
Difference between ADO and ADO.net ?
11 Answers Accenture, BirlaSoft, College School Exams Tests, Krest, Red Apple,
how Sequence to connect and retrieve data from database using dataset?
What does executequery return?
What is the role of the dataset object in ado.net?
How to bind the controls(best practice) comboboxes to the data in the dataset?
What is the difference between sqldatareader and sqldataadapter?
What are the differences between OLEDB and SQLClient Providers?
Describe briefly an ADO.NET Dataset ?
What is the difference between data reader and data adapter?
what is clustered index?why is it created?