Differentiate between SqlClient and OLEDB Provider
Differentiate between SqlClient and OLEDB Provider?
Expert
In terms of usage, there is no difference between SqlClient a ndOLEDB Provider. Difference lies in the performance. SqlClient is explicitly used to connect application to SQL server directly, where as OLEDB Provider is generic for a variety of databases, like Oracle and Access and also SQL Server. As a result there will be overhead that leads to performance degradation.
What are the chief built in objects in Asp.net?
Define the function of a ViewState property?
What is the duration for items stored in the ViewState?
Is it possible for users to define their own exceptions in code?
Explain how to store and retrieve images in the SQL server database via VB.NET?
Differentiate MDI form and a standard form?
Specify the advantages of the DOM?
What do you mean by the term delegate, why must you use it and explain how do you call it?
Briefly describe about data type?
What do you mean by Common Language Specification (CLS)?
18,76,764
1921864 Asked
3,689
Active Tutors
1414085
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!