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.
Describe the role of new keyword in brief.
State the different ways by which a method can be overloaded?
Differentiate between the Finalize() and Dispose()?
State the various advantages of cloud services?
Explain about the DataContext class and also how it is related to the LINQ?
Define the execution process of managed code?
Explain the use of Windows Installer.
State various limitations of the AJAX.
Briefly describe about XSLT?
How we can choose the color from a ColorDialog box?
18,76,764
1930106 Asked
3,689
Active Tutors
1453692
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!