OLEDB Provider and SqlClient
Write about the difference between OLEDB Provider and the SqlClient?
Expert
Regarding usage, there exists no difference between the OLEDB Provider and SqlClient. The dissimilarity lies in their performance. SqlClient is explicitly used in order to connect your application to the SQL server directly, OLEDB provider is generic for several databases, like Oracle and Access comprising SQL Server.
Thus, there will be an overhead that may leads to degradation of the performance.
List some of the new controls which are introduced in the ASP.NET AJAX Control Toolkit?
Illustrate the term lazy initialization?
Specify the way to suppress the final procedure inside the garbage collector forcibly in .NET?
What is meant by the XML DOM?
How a complex number can be instantiated?
When.NET was developed?
Elucidate Role based security?
Distinguish between the .EXE and .DLL files?
Name the parameters which control generally connection pooling behaviours?
Write the name of the methods available in .NET 4.0, which are used to add and delete items from the ListBox control?
18,76,764
1936324 Asked
3,689
Active Tutors
1412737
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!