DbConnectionBase Class

Represents an open connection to a server.

For a list of all members of this type, see DbConnectionBase members.

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DbConnection
            Devart.Common.DbConnectionBase
               Devart.Data.Oracle.OracleConnection

Syntax

[Visual Basic]
Public MustInherit Class DbConnectionBase 
   Inherits DbConnection
   Implements IComponent, IDbConnection, IDisposable

[C#]
public abstract class DbConnectionBase : DbConnection, IComponent, IDbConnection, IDisposable

Remarks

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

Example

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

[C#]

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

See Also

Language