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.
Distinguish among in-proc and out-of-proc
Define the terms Web server controls and Custom user Controls in Asp.net?
How the customized properties of .NET application can be retrieved from XML .config file?
Explain the types of deployment models which are used in the cloud?
Explain the following methods DataAdapter.Update() and DataSetAcceptChanges()?
Write the main difference between UnBoxing and boxing.
Can the 'throws' clause can be used to raise an exception?
Specify the differences between the Dispose() and Finalize() methods.
Write the difference between globalization and localization?
Illustrate the use of CommandBuilder class?
18,76,764
1956780 Asked
3,689
Active Tutors
1414479
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!