OracleTransaction Klasse

Definition

public ref class OracleTransaction sealed : MarshalByRefObject, IDisposable, System::Data::IDbTransaction

public ref class OracleTransaction sealed : System::Data::Common::DbTransaction

public sealed class OracleTransaction : MarshalByRefObject, IDisposable, System.Data.IDbTransaction

public sealed class OracleTransaction : System.Data.Common.DbTransaction

type OracleTransaction = class
    inherit MarshalByRefObject
    interface IDbTransaction
    interface IDisposable

type OracleTransaction = class
    inherit DbTransaction

Public NotInheritable Class OracleTransaction
Inherits MarshalByRefObject
Implements IDbTransaction, IDisposable

Public NotInheritable Class OracleTransaction
Inherits DbTransaction

Vererbung

Object

MarshalByRefObject

OracleTransaction

Vererbung

Object

MarshalByRefObject

DbTransaction

OracleTransaction

Implementiert

IDbTransaction IDisposable

Beispiele

Das folgende Beispiel erstellt eine OracleConnection und ein OracleTransaction. Außerdem wird veranschaulicht, wie die BeginTransactionMethoden , Commitund Rollback verwendet werden.

public void RunOracleTransaction(string connectionString)
{
    using (OracleConnection connection = new OracleConnection(connectionString))
    {
        connection.Open();

        OracleCommand command = connection.CreateCommand();
        OracleTransaction transaction;

        // Start a local transaction
        transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
        // Assign transaction object for a pending local transaction
        command.Transaction = transaction;

        try
        {
            command.CommandText =
                "INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')";
            command.ExecuteNonQuery();
            command.CommandText =
                "INSERT INTO Dept (DeptNo, Dname, Loc) values (60, 'ENGINEERING', 'KANSAS CITY')";
            command.ExecuteNonQuery();
            transaction.Commit();
            Console.WriteLine("Both records are written to database.");
        }
        catch (Exception e)
        {
            transaction.Rollback();
            Console.WriteLine(e.ToString());
            Console.WriteLine("Neither record was written to database.");
        }
    }
}

Public Sub RunOracleTransaction(ByVal connectionString As String)
    Using connection As New OracleConnection(connectionString)
        connection.Open()

        Dim command As OracleCommand = connection.CreateCommand()
        Dim transaction As OracleTransaction

        ' Start a local transaction
        transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted)
        ' Assign transaction object for a pending local transaction
        command.Transaction = transaction

        Try
            command.CommandText = _
                "INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')"
            command.ExecuteNonQuery()
            command.CommandText = _
                "INSERT INTO Dept (DeptNo, Dname, Loc) values (60, 'ENGINEERING', 'KANSAS CITY')"
            command.ExecuteNonQuery()
            transaction.Commit()
            Console.WriteLine("Both records are written to database.")
        Catch e As Exception
            transaction.Rollback()
            Console.WriteLine(e.ToString())
            Console.WriteLine("Neither record was written to database.")
        End Try
    End Using
End Sub

Hinweise

Die Anwendung erstellt ein OracleTransaction -Objekt, indem sie das OracleConnection -Objekt aufruftBeginTransaction. Alle nachfolgenden Vorgänge, die der Transaktion zugeordnet sind (z. B. Commit oder Abbruch der Transaktion), werden für das OracleTransaction Objekt ausgeführt.

Eigenschaften

Methoden

Explizite Schnittstellenimplementierungen

Gilt für:

Weitere Informationen

• OracleDataAdapter
• OracleConnection