dotConnect for Oracle Documentation
Connection Property
See Also  Example
Devart.Data.Oracle Namespace > OracleCommand Class : Connection Property

Gets or sets the OracleConnection used by this instance of the Devart.Data.Oracle.OracleCommand.


Visual Basic (Declaration) 
Public Shadows Property Connection As OracleConnection
public new OracleConnection Connection {get; set;}

Property Value

The connection to a data source. The default value is a null reference.


OracleConnection specified in this property will carry out all operations executed with this Devart.Data.Oracle.OracleCommand.

This property supports the InterForm technology.


The following example creates a Devart.Data.Oracle.OracleCommand and sets some of its properties.
C#csharpCopy Code
public void CreateCommand()
  string mySelectQuery = "SELECT * FROM Test.Dept ORDER BY DeptNo";
  OracleCommand myCommand = new OracleCommand(mySelectQuery);
  myCommand.Connection = new OracleConnection(
    "User Id=Scott;Password=tiger;Data Source=Ora;");
  myCommand.CommandType = System.Data.CommandType.Text;
C#Visual BasicCopy Code
Public Sub CreateCommand()
  Dim mySelectQuery As String = _
    "SELECT * FROM Test.Dept ORDER BY DeptNo"
  Dim myCommand As New OracleCommand(mySelectQuery)
  myCommand.Connection = New OracleConnection( _
    "User Id=Scott;Password=tiger;Data Source=Ora;")
  myCommand.CommandType = System.Data.CommandType.Text
End Sub


Platforms:Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family, Windows 7, Windows 8, Windows 10, Windows Server 2012 family.

See Also