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.
Write the name of the new method that has been introduced in ASP.NET 4.0 to redirect the page permanently?
Explain the use of a CommandBuilder class?
State some of the use of ScriptManager control in the AJAX?
Write down the use of console application in brief?
Explain the use of App_Code folder in ASP.NET?
Write down in brief the various types of Triggers in the WPF?
What is the duration for items stored in the ViewState?
State how the changes made to the DataSet object are identified since it was last loaded?
Write differences between the while and for loop in C#.
Name the different methods provided by a DataSet object to create XML?
18,76,764
1949030 Asked
3,689
Active Tutors
1421412
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!