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 |
can u tell me the why ADO does not support xml..
What does executenonquery () method return?
What is oledb connection?
What are the key events of sqlconnection class?
What are the advantages and drawbacks of using ado.net?
What is namespace in ado.net?
What is the namespaces being used to access oracle database?
What are the differences between OLEDB and SQLClient Providers?
Explain how to create dynamic gridview?
If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?
What is difference between ado.net and asp net?
How do u implement locking concept for dataset?