DbCommandBase Class

In This Topic

Represents a SQL statement or stored procedure to execute against a data source.

Syntax

Visual Basic
C#

'Declaration
 
Public MustInherit Class DbCommandBase 
   Inherits System.Data.Common.DbCommand
   Implements System.ComponentModel.IComponent, System.Data.IDbCommand, System.IDisposable

public abstract class DbCommandBase : System.Data.Common.DbCommand, System.ComponentModel.IComponent, System.Data.IDbCommand, System.IDisposable

Remarks

Abstract DbCommandBase class implements some of DbCommandBase 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 DeptNo, DName, Loc FROM Test.Dept";
        myConnection.Open();
        DbDataReader myReader = myCommand.ExecuteReader();
        try {
                while (myReader.Read()) {
                        Console.WriteLine(myReader.GetInt32(0).ToString() + " " + 
                                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 DeptNo, DName, Loc FROM Test.Dept"
        myConnection.Open()
        Dim myReader As DbDataReader = myCommand.ExecuteReader()
        Try
                While myReader.Read()
                        Console.WriteLine(String.Concat(myReader.GetInt32(0).ToString(), " ", _
                                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.DbCommand
            Devart.Common.DbCommandBase
               Devart.Data.SqlShimCommand

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

DbCommandBase Members
Devart.Common Namespace
DbCommandBase Class

Send Feedback