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 |
how to keep track of index in listbox items.
Which provider is used to connect ms access, oracle, etc…?
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
What is data relation in ado.net?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is the difference between ADO and ADO.Net?
Describe datareader object of ado.net with example.
How xml files and be read and write using dataset ?
What is a dataset?
What is the return type of executescalar?
What do you know about ADO.NET's objects and methods?
What is execute reader in ado.net?
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)