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 are the usages of the command object in ado.net?

780


What is difference between ado.net and asp net?

765


Describe the command object and its method.

764


What is the DataTableCollection?

819


What is a datareader object?

841


What is the executescalar method?

800


Which keyword is used to accept variable number of parameters?

889


What are datareaders?

703


What is ado circle?

897


What DataReader class do in ADO.NET ?

806


Is it possible to load multiple tables in a Dataset?

767


What is the difference between Command and CommandBuilder object?

805


What is the meaning of object pooling?

856


Explain how to find the given query is optimised one or not?

727


What is basic use of data view?

745