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 |
Difference between DataReader and DataAdapter / DataSet and DataAdapter?
What is the functionality of data provider in ado.net?
What does adodb stand for?
What is the difference between ado.net and entity framework?
Describe the disconnected architecture of ADO.NET’s data access model.
Define Execute Reader?
Which database is the ado.net sql connection object designed for?
What is microsoft ado?
What is method to get XML and schema from Dataset?
What are all the different authentication techniques used to connect to MS SQL Server?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
What is the key feature of ADO.NET compared to ADO ?
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)