OleDbConnection.BeginTransaction 方法

定義

命名空間:

System.Data.OleDb

組件:

System.Data.OleDb.dll

套件:

System.Data.OleDb v8.0.0

開始資料庫交易。

多載

BeginTransaction()	使用目前的 IsolationLevel 值來開始資料庫的交易。
BeginTransaction(IsolationLevel)	使用指定的隔離等級開始資料庫異動。

BeginTransaction()

來源:

OleDbConnection.cs

使用目前的 IsolationLevel 值來開始資料庫的交易。

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

傳回

OleDbTransaction

代表新異動的物件。

例外狀況

InvalidOperationException

不支援平行交易。

範例

下列範例會 OleDbConnection 建立 和 OleDbTransaction。 它也示範如何使用 BeginTransaction、 Commit和 Rollback 方法。

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

備註

您必須使用 Commit 或 Rollback 方法來明確認可或回復交易。 若要確定 .NET Framework OLE DB 交易管理模型的數據提供者會正確執行，請避免使用其他交易管理模型，例如數據源所提供的模型。

另請參閱

• 連接到資料來源

BeginTransaction(IsolationLevel)

來源:

OleDbConnection.cs

使用指定的隔離等級開始資料庫異動。

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

Public Function BeginTransaction (isolationLevel As IsolationLevel) As OleDbTransaction

參數

isolationLevel

IsolationLevel

應該在其下執行異動的隔離等級。

傳回

OleDbTransaction

代表新異動的物件。

例外狀況

InvalidOperationException

不支援平行交易。

範例

下列範例會 OleDbConnection 建立 和 OleDbTransaction。 它也示範如何使用 BeginTransaction、 Commit和 Rollback 方法。

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

備註

您必須使用 Commit 或 Rollback 方法來明確認可或回復交易。 若要確定 .NET Framework OLE DB 交易管理模型的數據提供者會正確執行，請避免使用其他交易管理模型，例如數據源所提供的模型。

注意

如果您未指定隔離等級，則會使用基礎提供者的默認隔離等級。 若要使用 BeginTransaction 方法指定隔離等級，請使用採用 參數的多 isolationLevel 載。

另請參閱

• 連接到資料來源