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 AccountID, \"Account Name\", Phone FROM Accounts";
        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 AccountID, \"Account Name\", Phone FROM Accounts"
        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.DbCommand
            Devart.Common.DbCommandBase
               Devart.Data.SqlShimCommand

Reference

DbCommandBase Members
Devart.Common Namespace
DbCommandBase Class

Send Feedback