dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class / OracleCommand Constructor / OracleCommand Constructor(String)
The text of the query.
Example

OracleCommand Constructor(String)
Initializes a new instance of the OracleCommand class with the text of the query.
Syntax
'Declaration
 
Public Function New( _
   ByVal commandText As String _
)
 

Parameters

commandText
The text of the query.
Remarks
The following table shows initial property values for an instance of OracleCommand.
Properties Initial value
CommandText commandText
Devart.Common.DbCommandBase.CommandTimeout 30
CommandType System.Data.CommandType.Text
Connection null
Example
The following example creates a OracleCommand and sets some of its properties.
public void CreateOracleCommand()
{
  string mySelectQuery = "SELECT * FROM Test.Dept";
  OracleCommand myCommand = new OracleCommand(mySelectQuery);
  myCommand.FetchSize = 100;
}
Public Sub CreateOracleCommand()
  Dim mySelectQuery As String = "SELECT * FROM Test.Dept"
  Dim myCommand As New OracleCommand(mySelectQuery)
  myCommand.FetchSize = 100
End Sub
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

See Also