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 |
Define connection string?
What is full form of ado?
Explain the differences between oledb sql server, oledbdotnet provider?
Explain the dataadapter class in ado.net?
Execute nonquery returns no. of afected rows.So if my stored procedure hav lot of select stmnt, delete stmnt, insert stmnt..then what does execute nonquery returns in this case?
What is data view and variable view?
what is bubbled event can u pls explain
what are the differences between dataset and datareader?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What is azure ado?
What is the difference between the clone() and copy() methods of the dataset class?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
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)