OdbcTransaction 類別
定義
重要
部分資訊涉及發行前產品，在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊，不做任何明確或隱含的瑕疵擔保。
表示要對數據源進行的 SQL 交易。 無法繼承這個類別。
public ref class OdbcTransaction sealed : System::Data::Common::DbTransactionpublic ref class OdbcTransaction sealed : MarshalByRefObject, IDisposable, System::Data::IDbTransactionpublic sealed class OdbcTransaction : System.Data.Common.DbTransactionpublic sealed class OdbcTransaction : MarshalByRefObject, IDisposable, System.Data.IDbTransactiontype OdbcTransaction = class
inherit DbTransactiontype OdbcTransaction = class
inherit MarshalByRefObject
interface IDbTransaction
interface IDisposablePublic NotInheritable Class OdbcTransaction
Inherits DbTransactionPublic NotInheritable Class OdbcTransaction
Inherits MarshalByRefObject
Implements IDbTransaction, IDisposable- 繼承
- 繼承
- 實作
範例
下列範例會建立 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
備註
應用程式會在 OdbcConnection 物件上呼叫 BeginTransaction，以建立 OdbcTransaction 物件。 與交易相關聯的所有後續作業（例如認可或中止交易）都會在 OdbcTransaction 對象上執行。
屬性
| Connection |
取得與交易相關聯的 OdbcConnection 物件，如果交易不再有效，則 |
| DbConnection |
在衍生類別中覆寫時，取得與交易相關聯的 DbConnection 物件。 (繼承來源 DbTransaction) |
| IsolationLevel |
指定此交易的 IsolationLevel。 |
| SupportsSavepoints |
取得值，這個值表示這個 DbTransaction 實例是否支援資料庫儲存點。
如果 |
方法
明確介面實作
| IDbTransaction.Connection |
取得與交易相關聯的 DbConnection 物件，如果交易不再有效，則為 Null 參考。 (繼承來源 DbTransaction) |
| IDisposable.Dispose() |
此 API 支援此產品基礎結構，但無法直接用於程式碼之中。 釋放目前 OdbcTransaction 類別實例所使用的資源。 |
擴充方法
| ConfigureAwait(IAsyncDisposable, Boolean) |
設定如何執行從異步可處置專案傳回的工作等候。 |
