dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleConnection Class / BeginTransaction Method / BeginTransaction() Method
Example

On this page
    BeginTransaction() Method
    On this page
    Begins a database transaction.
    Syntax
    'Declaration
     
    Public Overloads Shadows Function BeginTransaction() As OracleTransaction
    public new OracleTransaction BeginTransaction()

    Return Value

    An object representing the new transaction.
    Remarks
    To commit or roll back the transaction, you must explicitly use the Commit or Rollback methods.
    Example
    The following example creates a OracleConnection and a OracleTransaction. It also demonstrates how to use the BeginTransaction(), Commit, and Rollback methods.
    public void RunOracleTransaction(string myConnString)
    {
      OracleConnection oracleConnection = new OracleConnection(myConnString);
      oracleConnection.Open();
    
      OracleCommand oracleCommand = new OracleCommand();
      oracleCommand.Connection = oracleConnection;
      OracleTransaction myTrans;
    
      // Start a local transaction
      myTrans = oracleConnection.BeginTransaction();
      // Assign transaction object for a pending local transaction
      oracleCommand.Transaction = myTrans;
    
      try
      {
        oracleCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')";
        oracleCommand.ExecuteNonQuery();
        oracleCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(60, 'PRODUCTION')";
        oracleCommand.ExecuteNonQuery();
        myTrans.Commit();
        Console.WriteLine("Both records are written to database.");
      }
      catch(Exception e)
      {
        myTrans.Rollback();
        Console.WriteLine(e.ToString());
        Console.WriteLine("Neither record was written to database.");
      }
      finally
      {
        oracleConnection.Close();
      }
    }
    Public Sub RunOracleTransaction(myConnString As String)
      Dim oracleConnection As New OracleConnection(myConnString)
      oracleConnection.Open()
    
      Dim oracleCommand As New OracleCommand()
      oracleCommand.Connection = oracleConnection
      Dim myTrans As OracleTransaction
    
      ' Start a local transaction
      myTrans = oracleConnection.BeginTransaction()
      ' Assign transaction object for a pending local transaction
      oracleCommand.Transaction = myTrans
    
      Try
        oracleCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"
        oracleCommand.ExecuteNonQuery()
        oracleCommand.CommandText = "INSERT INTO Test.Dept(DeptNo, DName) Values(60, 'PRODUCTION')"
        oracleCommand.ExecuteNonQuery()
        myTrans.Commit()
        Console.WriteLine("Both records are written to database.")
      Catch e As Exception
        myTrans.Rollback()
        Console.WriteLine(e.ToString())
        Console.WriteLine("Neither record was written to database.")
      Finally
        oracleConnection.Close()
      End Try
    End Sub
    See Also