Difference between OLEDB Provider and SqlClient ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between entity framework and ado.net?

481


What are all the classes that are available in System.Data Namespace?

561


What is the difference between Command and CommandBuilder object?

591


What is the difference between connected and disconnected environment?

495


What is an ado connection?

529






What are the essential features of ado.net?

542


How do you update database through dataset?

544


What is ado net stands for?

518


What are the different ado.net namespaces?

626


What is ole in vb?

514


Define Execute Scalar?

555


What are the namespaces used in ado.net for data access?

485


What are disadvantages of microsoft-provided data provider classes in ado.net?

508


Which ado.net object is very fast in getting data from the database?

654


What is the significance of CommandBehavior.CloseConnection ?

575