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 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...
  • 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...
  • 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...
  • Siteminder Tutorials
    Siteminder Tutorials :: Conceptual Overview N-Tier Architecture Components SiteMinder Overview SiteMinder Components SiteMinder Features Sin...
  • 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 ...
  • 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...
  • SQL Interview Questions on JOINS
    <<PREV SQL Interview Questions on JOINS NEXT >> 21. Difference between char and nvarchar / char and varchar data-type? char[(n)...
Home | Site Index | Contact Us