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 asp?
Call a stored procedure from ado.net and pass parameter to it ?
7 Answers Keane India Ltd, TCS,
what are the differences between dataset and datareader?
What is XML serialization
What are the namespaces used in ado.net for data access?
What are typed and untyped dataset?
What is ado circle?
How to find the count of records in a dataset?
What is sqlconnection and sqlcommand?
What is sqldatareader in ado.net?
Write steps of retrieving data using ado.net ?
How xml files and be read and write using dataset ?
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)