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.
Name the different methods provided by a DataSet object to create XML?
Differentiate between a ContextMenuStrip control and a MenuStrip control?
Name the events that are fired during a page load?
Explain Common Type System (CTS)?
Illustrate how do you create a Cookie?
List some of the new controls which are introduced in the ASP.NET AJAX Control Toolkit?
How the customized properties of .NET application can be retrieved from XML .config file?
Explain the ToolTip control and how it can be associated with the other controls?
Name the different types of authentication techniques which are used in the connection strings to connect the .NET applications with the Microsoft SQL Server?
Distinguish the term Classic ASP as well as ASP.Net?
18,76,764
1958986 Asked
3,689
Active Tutors
1451559
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!