Frequently Asked Interview Questions

What is the difference between OleDb data provider and SqlClient?

SqlClient provides classes that are highly optimized to connect sql server using .Net. SqlClient data provider is faster than any other data provider in Ado.Net. It is faster because it connect sql data source directly using native library.
ADO.NETADO.Net Interview Questions >>
Posted by Ramu

Most Visited Pages

  • Unable to process SMSESSION cookie
      Unable to process SMSESSION cookie warning in siteminder webagent logs We could see this warning in siteminder web agent logs. user tries ...
  • Policy Server Failover
    Exercise 1 : Policy Server Failover In this exercise, you and a partner will configure your systems for policy server failover. You will cha...
  • Policy Server Clustering
    A cluster is a set of servers with dynamic load balancing. Load is dynamically distributed among the servers in a cluster. Trusted hosts can...
  • Policy Server Failover, Load Balancing and Clustering
    Overview Agent to Policy Server Failover Dynamic Load Balancing Policy Server Clustering Exercise 1: Policy Server Failover Exercise 2: Mult...
  • Siteminder Tutorials
    Siteminder Tutorials :: Conceptual Overview N-Tier Architecture Components SiteMinder Overview SiteMinder Components SiteMinder Features Sin...
  • Triggers in SQL
    What is a Trigger? A trigger is a special kind of stored procedure that is invoked whenever an attempt is made to modify the data in the tab...
  • What is a View?
    The view is a virtual table, which can have the multiple columns from the one or more table. It can be used like the normal table. Normally ...
  • C Sharp Interview Questions and Answers Part-4
    << PREV NEXT >> 31. What are advantages and disadvantages of data provider classes in ADO.NET? SQLServer.NET data provider is h...
  • Failover and Load Balancing
    Failover and Load Balancing SiteMinder allows the following failover and load balancing strategies: – Agent topolicy server o Failover...
  • N-Tier Architecture Components
    N-Tier Architecture Components Clients (Browser & Standalone Application) – managesuser (a.k.a. actors) interaction with the applica...
Home | Site Index | Contact Us