OleDbConnection.BeginTransaction Methode

Definition

Startet eine Datenbanktransaktion.Starts a database transaction.

Überlädt

BeginTransaction()

Beginnt eine Datenbanktransaktion mit dem aktuellen IsolationLevel-Wert.Starts a database transaction with the current IsolationLevel value.

BeginTransaction(IsolationLevel)

Startet eine Datenbanktransaktion mit dem angegebenen Isolationsgrad.Starts a database transaction with the specified isolation level.

BeginTransaction()

Beginnt eine Datenbanktransaktion mit dem aktuellen IsolationLevel-Wert.Starts a database transaction with the current IsolationLevel value.

public:
 System::Data::OleDb::OleDbTransaction ^ BeginTransaction();
public System.Data.OleDb.OleDbTransaction BeginTransaction ();
override this.BeginTransaction : unit -> System.Data.OleDb.OleDbTransaction
Public Function BeginTransaction () As OleDbTransaction

Gibt zurück

Ein Objekt, das die neue Transaktion darstellt.An object representing the new transaction.

Ausnahmen

Parallele Transaktionen werden nicht unterstützt.Parallel transactions are not supported.

Beispiele

Das folgende Beispiel erstellt eine OleDbConnection und ein OleDbTransaction.The following example creates an OleDbConnection and an OleDbTransaction. Außerdem wird veranschaulicht, wie die Methoden BeginTransaction, Commitund Rollback verwendet werden.It also demonstrates how to use the BeginTransaction, Commit, and Rollback methods.

public void ExecuteTransaction(string connectionString)
{
    using (OleDbConnection connection =
               new OleDbConnection(connectionString))
    {
        OleDbCommand command = new OleDbCommand();
        OleDbTransaction transaction = null;

        // Set the Connection to the new OleDbConnection.
        command.Connection = connection;

        // Open the connection and execute the transaction.
        try
        {
            connection.Open();

            // Start a local transaction with ReadCommitted isolation level.
            transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);

            // Assign transaction object for a pending local transaction.
            command.Connection = connection;
            command.Transaction = transaction;

            // Execute the commands.
            command.CommandText =
                "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
            command.ExecuteNonQuery();
            command.CommandText =
                "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";
            command.ExecuteNonQuery();

            // Commit the transaction.
            transaction.Commit();
            Console.WriteLine("Both records are written to database.");
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
            try
            {
                // Attempt to roll back the transaction.
                transaction.Rollback();
            }
            catch
            {
                // Do nothing here; transaction is not active.
            }
        }
        // The connection is automatically closed when the
        // code exits the using block.
    }
}
Public Sub ExecuteTransaction(ByVal connectionString As String)

    Using connection As New OleDbConnection(connectionString)
        Dim command As New OleDbCommand()
        Dim transaction As OleDbTransaction

        ' Set the Connection to the new OleDbConnection.
        command.Connection = connection

        ' Open the connection and execute the transaction.
        Try
            connection.Open()

            ' Start a local transaction with ReadCommitted isolation level.
            transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted)

            ' Assign transaction object for a pending local transaction.
            command.Connection = connection
            command.Transaction = transaction

            ' Execute the commands.
            command.CommandText = _
                "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"
            command.ExecuteNonQuery()
            command.CommandText = _
                "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')"
            command.ExecuteNonQuery()

            ' Commit the transaction.
            transaction.Commit()
            Console.WriteLine("Both records are written to database.")

        Catch ex As Exception
            Console.WriteLine(ex.Message)
            ' Try to rollback the transaction
            Try
                    transaction.Rollback()

            Catch
                ' Do nothing here; transaction is not active.
            End Try
        End Try
        ' The connection is automatically closed when the
        ' code exits the Using block.
    End Using
End Sub

Hinweise

Sie müssen die Transaktion mithilfe der Commit-oder Rollback Methode explizit ausführen oder zurücksetzen.You must explicitly commit or roll back the transaction using the Commit or Rollback method. Um sicherzustellen, dass die .NET Framework Datenanbieter für das OLE DB Transaktions Verwaltungsmodell ordnungsgemäß ausgeführt wird, sollten Sie keine anderen Transaktions Verwaltungsmodelle verwenden, wie z. b. die von der Datenquelle bereitgestellten.To make sure that the .NET Framework Data Provider for OLE DB transaction management model performs correctly, avoid using other transaction management models, such as those provided by the data source.

Siehe auch

BeginTransaction(IsolationLevel)

Startet eine Datenbanktransaktion mit dem angegebenen Isolationsgrad.Starts a database transaction with the specified isolation level.

public:
 System::Data::OleDb::OleDbTransaction ^ BeginTransaction(System::Data::IsolationLevel isolationLevel);
public System.Data.OleDb.OleDbTransaction BeginTransaction (System.Data.IsolationLevel isolationLevel);
override this.BeginTransaction : System.Data.IsolationLevel -> System.Data.OleDb.OleDbTransaction

Parameter

isolationLevel
IsolationLevel

Die Isolationsstufe, unter der die Transaktion ausgeführt werden soll.The isolation level under which the transaction should run.

Gibt zurück

Ein Objekt, das die neue Transaktion darstellt.An object representing the new transaction.

Ausnahmen

Parallele Transaktionen werden nicht unterstützt.Parallel transactions are not supported.

Beispiele

Das folgende Beispiel erstellt eine OleDbConnection und ein OleDbTransaction.The following example creates an OleDbConnection and an OleDbTransaction. Außerdem wird veranschaulicht, wie die Methoden BeginTransaction, a Commitund Rollback verwendet werden.It also demonstrates how to use the BeginTransaction, a Commit, and Rollback methods.

public void ExecuteTransaction(string connectionString)
{
    using (OleDbConnection connection =
               new OleDbConnection(connectionString))
    {
        OleDbCommand command = new OleDbCommand();
        OleDbTransaction transaction = null;

        // Set the Connection to the new OleDbConnection.
        command.Connection = connection;

        // Open the connection and execute the transaction.
        try
        {
            connection.Open();

            // Start a local transaction
            transaction = connection.BeginTransaction();

            // Assign transaction object for a pending local transaction.
            command.Connection = connection;
            command.Transaction = transaction;

            // Execute the commands.
            command.CommandText =
                "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
            command.ExecuteNonQuery();
            command.CommandText =
                "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";
            command.ExecuteNonQuery();

            // Commit the transaction.
            transaction.Commit();
            Console.WriteLine("Both records are written to database.");
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
            try
            {
                // Attempt to roll back the transaction.
                transaction.Rollback();
            }
            catch
            {
                // Do nothing here; transaction is not active.
            }
        }
        // The connection is automatically closed when the
        // code exits the using block.
    }
}
Public Sub ExecuteTransaction(ByVal connectionString As String)

    Using connection As New OleDbConnection(connectionString)
        Dim command As New OleDbCommand()
        Dim transaction As OleDbTransaction

        ' Set the Connection to the new OleDbConnection.
        command.Connection = connection

        ' Open the connection and execute the transaction.
        Try
            connection.Open()

            ' Start a local transaction.
            transaction = connection.BeginTransaction()

            ' Assign transaction object for a pending local transaction.
            command.Connection = connection
            command.Transaction = transaction

            ' Execute the commands.
            command.CommandText = _
                "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"
            command.ExecuteNonQuery()
            command.CommandText = _
                "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')"
            command.ExecuteNonQuery()

            ' Commit the transaction.
            transaction.Commit()
            Console.WriteLine("Both records are written to database.")

        Catch ex As Exception
            Console.WriteLine(ex.Message)
            ' Try to rollback the transaction
            Try
                    transaction.Rollback()

            Catch
                ' Do nothing here; transaction is not active.
            End Try
        End Try
        ' The connection is automatically closed when the
        ' code exits the Using block.
    End Using
End Sub

Hinweise

Sie müssen die Transaktion mithilfe der Commit-oder Rollback Methode explizit ausführen oder zurücksetzen.You must explicitly commit or roll back the transaction using the Commit or Rollback method. Um sicherzustellen, dass die .NET Framework Datenanbieter für das OLE DB Transaktions Verwaltungsmodell ordnungsgemäß ausgeführt wird, sollten Sie keine anderen Transaktions Verwaltungsmodelle verwenden, wie z. b. die von der Datenquelle bereitgestellten.To make sure that the .NET Framework Data Provider for OLE DB transaction management model performs correctly, avoid using other transaction management models, such as those provided by the data source.

Hinweis

Wenn Sie keine Isolationsstufe angeben, wird die Standard Isolationsstufe für den zugrunde liegenden Anbieter verwendet.If you do not specify an isolation level, the default isolation level for the underlying provider is used. Verwenden Sie die-Überladung, die den isolationLevel-Parameter annimmt, um eine Isolationsstufe mit der BeginTransaction-Methode anzugeben.To specify an isolation level with the BeginTransaction method, use the overload that takes the isolationLevel parameter.

Siehe auch

Gilt für: