Difference between OLEDB Provider and SqlClient ?
Answers were Sorted based on User's Feedback
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 |
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 |
Compare Data Reader & Dataset in ado.net?
What is dataset object? Explain the various objects in dataset.
What is typed dataset ?
Why do we serialize data?
What are the three Ado objects?
6 Answers Microsoft, StarSoft,
What are the steps to connect to a database?
Define isolation?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
How to add a javaScript function in a datagrid?
Which parameter of ConnectionString is used to specify the name of the database?
What does adodb stand for?
Where is adodb dll located?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)