Difference between OLEDB Provider and SqlClient ?
- 2 Answers
- 10078 Views
- I also Faced
- E-Mail Answers
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 |
What is executenonquery ado.net?
What is data view and variable view?
What are the Data providers in ADO.Net?
What are ado.net objects?
What is the use of SqlCommandBuilder?
How we can provide data to ado.net?
Explain what are acid properties?
What is a sqldataadapter?
Define ado.net?
How to create data relations?
What does ole stand for in excel?
How to insert multiple records in asp .net from Gridview to Sql Database with out using loop condition ?
-
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)
