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 data source-independent.

Example

The following sample demonstrates how using base classes helps to create data source independent code.

csharp

public void PrintDept(DbConnectionBase myConnection) {
        DbCommandBase myCommand = (DbCommandBase)myConnection.CreateCommand();
        myCommand.CommandText = "SELECT Id, FirstName, LastName FROM Client";
        myConnection.Open();
        DbDataReader myReader = myCommand.ExecuteReader();
        try {
                while (myReader.Read()) {
                        Console.WriteLine(myReader.GetString(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 Id, FirstName, LastName FROM Client"
        myConnection.Open()
        Dim myReader As DbDataReader = myCommand.ExecuteReader()
        Try
                While myReader.Read()
                        Console.WriteLine(String.Concat(myReader.GetString(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.SqlShimConnection

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
FreshBooksConnection Class

Send Feedback