dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class / CommandType Property
Example

In This Topic
    CommandType Property (OracleCommand)
    In This Topic
    Gets or sets a value indicating how the CommandText property is to be interpreted.
    Syntax
    'Declaration
     
    Public Overrides Property CommandType As CommandType
    public override CommandType CommandType {get; set;}

    Property Value

    One of the System.Data.CommandType values. The default value is System.Data.CommandType.Text.
    Remarks

    CommandType can be one of the following values: Text, StoredProcedure, TableDirect.

    When the value is CommandType.Text, the property CommandText should contain text of a query that must be run on the server.

    When the value is CommandType.StoredProcedure, CommandText property must be a name of a procedure to execute.

    When the value is set to TableDirect, CommandText must be name of a table you want to get all data from. All rows and columns are retrieved.

    Example
    The following example creates an instance of a derived class OracleCommand and sets some of its properties.
    public void CreateCommand()
    {
      OracleCommand myCommand = new OracleCommand();
      myCommand.CommandText = "SELECT * FROM Test.Dept ORDER BY DeptNo";
      myCommand.CommandType = CommandType.Text;
    }
    Public Sub CreateCommand()
      Dim myCommand As New OracleCommand()
      myCommand.CommandText = "SELECT * FROM Test.Dept ORDER BY DeptNo"
      myCommand.CommandType = CommandType.Text
    End Sub
    See Also