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

What is untyped dataset?

1 Answers  


What is the purpose of using adodb?

1 Answers  


What are the steps you will take to improve performance?

1 Answers  


What is the meaning of executenonquery?

1 Answers  


suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validation contrl for dd/mm/yy formator how we assign regular expression for same

9 Answers   TCS,


What is ole db and odbc?

1 Answers  


How can you implement sub data grid in a master datagrid?

1 Answers  


What are the 3 major types of connection objects in ado.net?

1 Answers  


How to find the count of records in a dataset?

6 Answers  


How many commands does the oledbcommand takes?what are they?

2 Answers  


What are the different execute methods of Ado.Net?

1 Answers  


What are all features of ADO.Net?

1 Answers  


Categories