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

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

796


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

688


What is the difference in record set and dataset?

734


What is difference between dataset and datatable?

764


What is difference between entity framework and ado.net?

689


What is command class in ado.net?

688


What is a column variable?

693


Which architecture does Datasets follow?

797


What is microsoft ado?

698


Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

885


Why do we use sqldataadapter?

712


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

776


What is the difference between executequery and executenonquery?

707


What are good ado.net object to replace to ado recordset object.

787


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

864