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

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

657


What is sqldatareader?

498


Define Execute Scalar?

559


What is Data view?

571


What is the use of ADO.NET and XML web services?

600






Difference between sqlcommand and sqlcommandbuilder?

591


What is oledb driver?

502


What are the different ado.net namespaces are available in .net?

505


Which namespaces are used for data access?

628


How to generate a single aggregate?

545


How to creating a SqlCommand Object?

597


What are the major challenges in accessing data from a database?

541


How to copy the contents from one table to another table and how to delete the source table in ado.net?

540


What do you know about ADO.NET's objects and methods?

528


What is difference between connected and disconnected architecture in ado.net?

594