OleDbConnection.BeginTransaction 方法

定义

命名空间:: System.Data.OleDb

程序集:: System.Data.OleDb.dll

程序集:: System.Data.dll

包:: System.Data.OleDb v11.0.0-preview.4.26230.115

重要

一些信息与预发行产品相关，相应产品在发行之前可能会进行重大修改。对于此处提供的信息，Microsoft 不作任何明示或暗示的担保。

启动数据库事务。

重载

名称	说明
BeginTransaction()	使用当前 IsolationLevel 值启动数据库事务。
BeginTransaction(IsolationLevel)	使用指定的隔离级别启动数据库事务。

BeginTransaction()

Source:: OleDbConnection.cs

Source:: OleDbConnection.cs

Source:: OleDbConnection.cs

Source:: OleDbConnection.cs

使用当前 IsolationLevel 值启动数据库事务。

public:
 System::Data::OleDb::OleDbTransaction ^ BeginTransaction();

public System.Data.OleDb.OleDbTransaction BeginTransaction();

override this.BeginTransaction : unit -> System.Data.OleDb.OleDbTransaction

member 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。若要确保 OLE DB 事务管理模型的 .NET Framework Data Provider能够正确执行，请避免使用其他事务管理模型，例如数据源提供的模型。

另请参阅

连接到数据源

适用于

BeginTransaction(IsolationLevel)

Source:: OleDbConnection.cs

Source:: OleDbConnection.cs

Source:: OleDbConnection.cs

Source:: 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

member this.BeginTransaction : System.Data.IsolationLevel -> System.Data.OleDb.OleDbTransaction

Public Function BeginTransaction (isolationLevel As IsolationLevel) As OleDbTransaction

参数

isolationLevel: IsolationLevel

事务应在其下运行的隔离级别。

OleDbTransaction

表示新事务的对象。

例外

InvalidOperationException

不支持并行事务。

示例

以下示例创建一个 OleDbConnection 和一个 OleDbTransaction。它还演示了如何使用 BeginTransaction、a 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

注解

注释

如果未指定隔离级别，则使用基础提供程序的默认隔离级别。若要使用 BeginTransaction 该方法指定隔离级别，请使用采用参数的 isolationLevel 重载。

另请参阅

连接到数据源

适用于

反馈

此页面是否有帮助？

OleDbConnection.BeginTransaction 方法

定义

重载

BeginTransaction()

返回

例外

示例

注解

另请参阅

适用于

BeginTransaction(IsolationLevel)

参数

返回

例外

示例

注解

另请参阅

适用于