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

On this page
    BeginTransaction(IsolationLevel) Method
    On this page
    Begins a database transaction with the specified isolation level.
    Syntax
    'Declaration
     
    Public Overloads Shadows Function BeginTransaction( _
       ByVal il As IsolationLevel _
    ) As OracleTransaction
    public new OracleTransaction BeginTransaction( 
       IsolationLevel il
    )

    Parameters

    il

    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(IsolationLevel.ReadCommitted);
      // Assign transaction object for a pending local transaction
      oracleCommand.Transaction = myTrans;
    
      try
      {
        oracleCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')";
        oracleCommand.ExecuteNonQuery();
        oracleCommand.CommandText = "INSERT INTO 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(IsolationLevel.ReadCommitted)
      ' Assign transaction object for a pending local transaction
      oracleCommand.Transaction = myTrans
    
      Try
        oracleCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(50, 'DEVELOPMENT')"
        oracleCommand.ExecuteNonQuery()
        oracleCommand.CommandText = "INSERT INTO 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