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.
How can you avoid a class from overriding in C# and Visual Basic?
Is it possible to set which kind of comparison we want to perform by the CompareValidator control?
The information, like role management membership, profile, and Web parts personalization is stored in which database?
Why XMLHttpRequest object is used in the AJAX?
Define the term TrackBar control.
What is covariance and contra-variance in .NET Framework 4.0 with example for each.
Explain the role of a DISTINCT clause in the LINQ query?
Write down the different ways of hosting the WCF service?
Explain the use of a CommandBuilder class?
Distinguish between Codebehind="MyCode.aspx.cs" and Src="MyCode.aspx.cs"?
18,76,764
1952234 Asked
3,689
Active Tutors
1428417
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!