Frequently Asked Interview Questions

What are the data providers available in .net to connect to database?

  1. System.Data.SqlClient: It describes a collection of classes used to access a SQL Server database.
  2. System.Data.OleDb: It describes a collection of classes used to access an OleDb data source. (Microsoft Access, MySQL, Informix, DB2, Oracle.. It uses OleDB drivers to connect to data source)
  3. System.Data.Odbc: It describes a collection of classes that are used to access a ODBC data source. (We can connect any relation database which supports odbc drivers).
  4. System.Data.OracleClient: It describes a collection of classes that are used to connect Oracle Database.
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