DbConnectionBase Class

In This Topic

Represents an open connection to a server.

Syntax

Visual Basic
C#

'Declaration
 
Public MustInherit Class DbConnectionBase 
   Inherits System.Data.Common.DbConnection
   Implements System.ComponentModel.IComponent, System.Data.IDbConnection, System.IDisposable

public abstract class DbConnectionBase : System.Data.Common.DbConnection, System.ComponentModel.IComponent, System.Data.IDbConnection, System.IDisposable

Remarks

The abstract DbConnectionBase class implements some of DbConnectionBase functionality that is DBMS-independent.

Example

The following sample demonstrates how using base classes helps to create database-independent code.

csharp

public void PrintDept(DbConnectionBase myConnection) {
        DbCommandBase myCommand = (DbCommandBase)myConnection.CreateCommand();
        myCommand.CommandText = "SELECT * FROM Test.Dept";
        myConnection.Open();
        DbDataReader myReader = myCommand.ExecuteReader();
        try {
                while (myReader.Read()) {
                        Console.WriteLine(myReader.GetInt32(0) + " " + 
                                myReader.GetString(1) + " " + myReader.GetString(2));
                }
        }
        finally {
                myReader.Close();
                myConnection.Close();
        }
}

Visual Basic

Public Sub PrintDept(ByVal myConnection As DbConnectionBase)
        Dim myCommand As DbCommandBase = myConnection.CreateCommand()
        myCommand.CommandText = "SELECT * FROM Test.Dept"
        myConnection.Open()
        Dim myReader As DbDataReader = myCommand.ExecuteReader()
        Try
                While myReader.Read()
                        Console.WriteLine(String.Concat(myReader.GetInt32(0), " ", _
                                myReader.GetString(1), " ", myReader.GetString(2)))
                End While
        Finally
                myReader.Close()
                myConnection.Close()
        End Try
End Sub

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DbConnection
            Devart.Common.DbConnectionBase
               Devart.Data.SqlServer.SqlConnection

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DbConnectionBase Members
Devart.Common Namespace
DbConnectionBase Class
SqlConnection Class

Send Feedback