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 |
What is ado.net in mvc?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is fill method in ado.net?
Does ado.net use odbc?
Advantage of ADO.Net?
What is the provider being used to access oracle database?
What is ado.net full form?
Can we load multiple tables in a dataset?
What is @@rowcount and with small code snippet explain the usage?
How can we load multiple tables in a dataset?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
What is ole db query?
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)