OracleTransaction Class

In This Topic

Represents a SQL transaction to be made in the Oracle database.

Syntax

Visual Basic
C#

'Declaration
 
Public Class OracleTransaction 
   Inherits Devart.Common.DbTransactionBase
   Implements System.Data.IDbTransaction, System.IDisposable

public class OracleTransaction : Devart.Common.DbTransactionBase, System.Data.IDbTransaction, System.IDisposable

Remarks

The application creates a OracleTransaction object by calling OracleConnection.BeginTransaction on the OracleConnection object. All subsequent operations associated with the transaction (for example, committing or aborting the transaction), are performed on the OracleTransaction object.

The correlation between OracleConnection and OracleTransaction is always 1:1.

Example

The following example creates a OracleConnection and a OracleTransaction. It also demonstrates how to use the OracleConnection.BeginTransaction, Commit, and Rollback methods.

csharp

public static void RunOracleTransaction(string myConnString) {
        using (OracleConnection myConnection = new OracleConnection(myConnString)) {
                myConnection.Open();
                // Start a local transaction
                OracleTransaction myTrans = myConnection.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
                OracleCommand myCommand = myConnection.CreateCommand();
                try {
                        myCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(52, 'DEVELOPMENT')";
                        myCommand.ExecuteNonQuery();
                        myCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(62, 'PRODUCTION')";
                        myCommand.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 {
                        myCommand.Dispose();
                        myTrans.Dispose();
                }
    }
}

Visual Basic

Public Shared Sub RunOracleTransaction(myConnString As String)
        Using myConnection As New OracleConnection(myConnString)
                myConnection.Open()
                ' Start a local transaction
                Dim myTrans As OracleTransaction = myConnection.BeginTransaction(System.Data.IsolationLevel.ReadCommitted)
                Dim myCommand As OracleCommand = myConnection.CreateCommand()
                Try
                        myCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(52, 'DEVELOPMENT')"
                        myCommand.ExecuteNonQuery()
                        myCommand.CommandText = "INSERT INTO Dept(DeptNo, DName) Values(62, 'PRODUCTION')"
                        myCommand.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
                        myCommand.Dispose()
                        myTrans.Dispose()
                End Try
    End Using
End Sub

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.Data.Common.DbTransaction
         Devart.Common.DbTransactionBase
            Devart.Data.Oracle.OracleTransaction

Reference

OracleTransaction Members
Devart.Data.Oracle Namespace
OracleDataReader Class
OracleConnection Class

Send Feedback