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 ole in vb?
What is data access pattern?
What is openrowset?
What is the maximum pool size in ado.net connection string?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
How do you merge two datasets into the third dataset in a simple manner?
How to Handle the exceptions in Sqlsrver2000
What is difference between sqldatareader and sqldataadapter?
What is ole db and odbc?
What is connection string?
Explain acid properties?
What is linq and entity framework?