OracleCommand Construtores

Definição

Inicializa uma nova instância do OracleCommand.Initializes a new instance of the OracleCommand.

Sobrecargas

OracleCommand()

Inicializa uma nova instância do OracleCommand.Initializes a new instance of the OracleCommand.

OracleCommand(String)

Inicializa uma nova instância da classe OracleCommand com o texto da consulta.Initializes a new instance of the OracleCommand class with the text of the query.

OracleCommand(String, OracleConnection)

Inicializa uma nova instância da classe OracleCommand com o texto da consulta e um objeto OracleConnection.Initializes a new instance of the OracleCommand class with the text of the query and an OracleConnection object.

OracleCommand(String, OracleConnection, OracleTransaction)

Inicializa uma nova instância da classe OracleCommand com o texto da consulta, um objeto OracleConnection e um OracleTransaction.Initializes a new instance of the OracleCommand class with the text of the query, an OracleConnection object, and an OracleTransaction.

OracleCommand()

Inicializa uma nova instância do OracleCommand.Initializes a new instance of the OracleCommand.

public:
 OracleCommand();
public OracleCommand ();
Public Sub New ()

Exemplos

O exemplo a seguir cria um OracleCommand e define algumas de suas propriedades.The following example creates an OracleCommand and sets some of its properties.

public void CreateOracleCommand()
{
   OracleCommand command = new OracleCommand();
   command.CommandType = CommandType.Text;
}
Public Sub CreateOracleCommand()
    Dim command As New OracleCommand()
    command.CommandType = CommandType.Text
End Sub

Comentários

O construtor base inicializa todos os campos com seus valores padrão.The base constructor initializes all fields to their default values. A tabela a seguir mostra os valores de propriedade inicial para uma instância do OracleCommand .The following table shows initial property values for an instance of OracleCommand.

PropriedadesProperties Valor inicialInitial Value
CommandText Cadeia de caracteres vazia ("")empty string ("")
CommandType Text
Connection nullnull

Aplica-se a

OracleCommand(String)

Inicializa uma nova instância da classe OracleCommand com o texto da consulta.Initializes a new instance of the OracleCommand class with the text of the query.

public:
 OracleCommand(System::String ^ commandText);
public OracleCommand (string commandText);
new System.Data.OracleClient.OracleCommand : string -> System.Data.OracleClient.OracleCommand
Public Sub New (commandText As String)

Parâmetros

commandText
String

O texto da consulta.The text of the query.

Aplica-se a

OracleCommand(String, OracleConnection)

Inicializa uma nova instância da classe OracleCommand com o texto da consulta e um objeto OracleConnection.Initializes a new instance of the OracleCommand class with the text of the query and an OracleConnection object.

public:
 OracleCommand(System::String ^ commandText, System::Data::OracleClient::OracleConnection ^ connection);
public OracleCommand (string commandText, System.Data.OracleClient.OracleConnection connection);
new System.Data.OracleClient.OracleCommand : string * System.Data.OracleClient.OracleConnection -> System.Data.OracleClient.OracleCommand
Public Sub New (commandText As String, connection As OracleConnection)

Parâmetros

commandText
String

O texto da consulta.The text of the query.

connection
OracleConnection

Um objeto OracleConnection que representa a conexão com um banco de dados.An OracleConnection object that represents the connection to a database.

Exemplos

O exemplo a seguir cria um OracleCommand .The following example creates an OracleCommand.

public void CreateOracleCommand()
{
   OracleConnection connection = new OracleConnection("Data Source=Oracle8i;Integrated Security=yes");
   string queryString = "SELECT * FROM Emp ORDER BY EmpNo";
   OracleCommand command = new OracleCommand(queryString, connection);
}
Public Sub CreateOracleCommand()
    Dim connection As New OracleConnection _
       ("Data Source=Oracle8i;Integrated Security=yes")
    Dim queryString As String = _
       "SELECT * FROM Emp ORDER BY EmpNo"
    Dim command As New OracleCommand(queryString, connection)
End Sub

Aplica-se a

OracleCommand(String, OracleConnection, OracleTransaction)

Inicializa uma nova instância da classe OracleCommand com o texto da consulta, um objeto OracleConnection e um OracleTransaction.Initializes a new instance of the OracleCommand class with the text of the query, an OracleConnection object, and an OracleTransaction.

public:
 OracleCommand(System::String ^ commandText, System::Data::OracleClient::OracleConnection ^ connection, System::Data::OracleClient::OracleTransaction ^ tx);
public OracleCommand (string commandText, System.Data.OracleClient.OracleConnection connection, System.Data.OracleClient.OracleTransaction tx);
new System.Data.OracleClient.OracleCommand : string * System.Data.OracleClient.OracleConnection * System.Data.OracleClient.OracleTransaction -> System.Data.OracleClient.OracleCommand
Public Sub New (commandText As String, connection As OracleConnection, tx As OracleTransaction)

Parâmetros

commandText
String

O texto da consulta.The text of the query.

connection
OracleConnection

Um objeto OracleConnection que representa a conexão com um banco de dados.An OracleConnection object that represents the connection to a database.

tx
OracleTransaction

O OracleTransaction no qual o OracleCommand é executado.The OracleTransaction in which the OracleCommand executes.

Exemplos

O exemplo a seguir cria um OracleCommand e define algumas de suas propriedades.The following example creates an OracleCommand and sets some of its properties.

public void CreateOracleCommand(string connectionString)
{
    using (OracleConnection connection = new OracleConnection(connectionString))
    {
        connection.Open();
        OracleTransaction transaction = connection.BeginTransaction();
        string queryString = "SELECT * FROM Emp ORDER BY EmpNo";
        OracleCommand command = new OracleCommand(queryString, connection, transaction);
        command.CommandType = CommandType.Text;
    }
}
Public Sub CreateOracleCommand(ByVal connectionString As String)
    Using connection As New OracleConnection(connectionString)
        connection.Open()
        Dim transaction As OracleTransaction = connection.BeginTransaction()
        Dim queryString As String = _
           "SELECT * FROM Emp ORDER BY EmpNo"
        Dim command As New OracleCommand(queryString, connection, transaction)
        command.CommandType = CommandType.Text
    End Using
End Sub

Comentários

A tabela a seguir mostra os valores de propriedade inicial para uma instância dessa implementação do OracleCommand .The following table shows initial property values for an instance of this implementation of the OracleCommand.

PropriedadesProperties Valor inicialInitial Value
CommandText cmdText
CommandType Text
Connection Um novo OracleConnection que é o valor para o connection parâmetro.A new OracleConnection that is the value for the connection parameter.

Você pode alterar o valor de qualquer um desses parâmetros definindo a propriedade related.You can change the value for any of these parameters by setting the related property.

Aplica-se a