Difference between OLEDB Provider and SqlClient ?

Answers were Sorted based on User's Feedback



Difference between OLEDB Provider and SqlClient ?..

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

Difference between OLEDB Provider and SqlClient ?..

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

Post New Answer

More ADO.NET Interview Questions

can u tell me the why ADO does not support xml..

2 Answers   Crea,


What does executenonquery () method return?

0 Answers  


What is oledb connection?

0 Answers  


What are the key events of sqlconnection class?

0 Answers  


What are the advantages and drawbacks of using ado.net?

0 Answers  






What is namespace in ado.net?

0 Answers  


What is the namespaces being used to access oracle database?

0 Answers  


What are the differences between OLEDB and SQLClient Providers?

0 Answers  


Explain how to create dynamic gridview?

0 Answers  


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?

4 Answers   Honeywell,


What is difference between ado.net and asp net?

0 Answers  


How do u implement locking concept for dataset?

2 Answers   ABC,


Categories