Frequently Asked Interview Questions

What is the difference between DataReader and DataAdapter?

DataReader Vs DataAdapter.
  • DataReader provde read only and forward only data access.
  • DataReader can increase application performance and reduce system overhead.
  • DataReader is connection oriented where as Data Adapter is disconnected.
  • DataReader we have to open and close connection explicitly where as if we use DataAdapter the connection is automatically opened and closed.
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