OleDbConnection.BeginTransaction OleDbConnection.BeginTransaction OleDbConnection.BeginTransaction OleDbConnection.BeginTransaction Method

Definition

Startet eine Datenbanktransaktion.Starts a database transaction.

Überlädt

BeginTransaction() BeginTransaction() BeginTransaction() BeginTransaction()

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

BeginTransaction(IsolationLevel) BeginTransaction(IsolationLevel) BeginTransaction(IsolationLevel)

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

BeginTransaction() BeginTransaction() BeginTransaction() BeginTransaction()

Startet 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 Sie mit der BeginTransaction, Commit, und Rollback Methoden.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 explizit einen commit oder Rollback der Transaktion mithilfe der Commit oder Rollback Methode.You must explicitly commit or roll back the transaction using the Commit or Rollback method. Um sicherzustellen, dass die .NET Framework-Datenanbieter für OLE DB-Transaktion-Management-Modell ordnungsgemäß funktioniert, verwenden Sie keine andere Transaktionsverwaltungsmodelle, z. B. die von der Datenquelle.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) BeginTransaction(IsolationLevel) 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 IsolationLevel 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 Sie mit der BeginTransaction, Commit, und Rollback Methoden.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 explizit einen commit oder Rollback der Transaktion mithilfe der Commit oder Rollback Methode.You must explicitly commit or roll back the transaction using the Commit or Rollback method. Um sicherzustellen, dass die .NET Framework-Datenanbieter für OLE DB-Transaktion-Management-Modell ordnungsgemäß funktioniert, verwenden Sie keine andere Transaktionsverwaltungsmodelle, z. B. die von der Datenquelle.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 eine Isolationsstufe nicht angeben, wird die Standardisolationsstufe 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. An eine Isolationsstufe an, mit der BeginTransaction -Methode, verwenden Sie die Überladung, die akzeptiert die isolationLevel Parameter.To specify an isolation level with the BeginTransaction method, use the overload that takes the isolationLevel parameter.

Siehe auch

Gilt für: