OdbcConnection.BeginTransaction 方法

定義

命名空間:: System.Data.Odbc

組件:: System.Data.Odbc.dll

組件:: System.Data.dll

套件:: System.Data.Odbc v11.0.0-rc.1.26425.128

重要

部分資訊涉及發行前產品，在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊，不做任何明確或隱含的瑕疵擔保。

在數據源啟動交易。

多載

名稱	Description
BeginTransaction()	在數據源啟動交易。
BeginTransaction(IsolationLevel)	在指定值的資料來源 IsolationLevel 開始交易。

BeginTransaction()

來源:: OdbcConnection.cs

來源:: OdbcConnection.cs

來源:: OdbcConnection.cs

來源:: OdbcConnection.cs

在數據源啟動交易。

public:
 System::Data::Odbc::OdbcTransaction ^ BeginTransaction();

public System.Data.Odbc.OdbcTransaction BeginTransaction();

override this.BeginTransaction : unit -> System.Data.Odbc.OdbcTransaction

member this.BeginTransaction : unit -> System.Data.Odbc.OdbcTransaction

Public Function BeginTransaction () As OdbcTransaction

傳回

OdbcTransaction

一個代表新交易的物件。

例外狀況

InvalidOperationException

目前有交易正在進行中。不支援平行交易。

範例

以下範例可產生一個 OdbcConnection 和 OdbcTransaction。同時示範如何使用 BeginTransaction、 Commit及 Rollback 方法。

public static void ExecuteTransaction(string connectionString)
{
    using (OdbcConnection connection =
               new OdbcConnection(connectionString))
    {
        OdbcCommand command = new OdbcCommand();
        OdbcTransaction transaction = null;

        // Set the Connection to the new OdbcConnection.
        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 OdbcConnection(connectionString)
        Dim command As New OdbcCommand()
        Dim transaction As OdbcTransaction

        ' Set the Connection to the new OdbcConnection.
        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 OR Rollback 方法。

為確保 .NET Framework Data Provider for ODBC 交易管理模型能正常運作，請避免使用其他交易管理模型，例如資料來源提供的。

Note

若未指定隔離等級，隔離等級將由所用驅動單元決定。若要用方法 BeginTransaction 指定隔離層級，請使用取參數 isolevel 的超載。

另請參閱

連接資料來源

適用於

BeginTransaction(IsolationLevel)

來源:: OdbcConnection.cs

來源:: OdbcConnection.cs

來源:: OdbcConnection.cs

來源:: OdbcConnection.cs

在指定值的資料來源 IsolationLevel 開始交易。

public:
 System::Data::Odbc::OdbcTransaction ^ BeginTransaction(System::Data::IsolationLevel isolevel);

public System.Data.Odbc.OdbcTransaction BeginTransaction(System.Data.IsolationLevel isolevel);

override this.BeginTransaction : System.Data.IsolationLevel -> System.Data.Odbc.OdbcTransaction

member this.BeginTransaction : System.Data.IsolationLevel -> System.Data.Odbc.OdbcTransaction

Public Function BeginTransaction (isolevel As IsolationLevel) As OdbcTransaction

參數

isolevel: IsolationLevel

此連線的交易隔離層級。若未指定隔離等級，則使用驅動程式的預設隔離等級。

傳回