c# oracle commit,OracleTransaction

認可 SQL 資料庫交易。Commits the SQL database transaction.

public:

virtual void Commit();

public:

override void Commit();

public void Commit ();

public override void Commit ();

abstract member Commit : unit -> unit

override this.Commit : unit -> unit

override this.Commit : unit -> unit

Public Sub Commit ()

Public Overrides Sub Commit ()

實作

例外狀況

嘗試認可交易時發生錯誤。An error occurred while trying to commit the transaction.

已認可或復原交易。The transaction has already been committed or rolled back.

-或--or-

連線已中斷。The connection is broken.

範例

public void RunOracleTransaction(string connectionString)

{

using (OracleConnection connection = new OracleConnection(connectionString))

{

connection.Open();

OracleCommand command = connection.CreateCommand();

OracleTransaction transaction;

// Start a local transaction

transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);

// Assign transaction object for a pending local transaction

command.Transaction = transaction;

try

{

command.CommandText =

"INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')";

command.ExecuteNonQuery();

command.CommandText =

"INSERT INTO Dept (DeptNo, Dname, Loc) values (60, 'ENGINEERING', 'KANSAS CITY')";

command.ExecuteNonQuery();

transaction.Commit();

Console.WriteLine("Both records are written to database.");

}

catch (Exception e)

{

transaction.Rollback();

Console.WriteLine(e.ToString());

Console.WriteLine("Neither record was written to database.");

}

}

}Public Sub RunOracleTransaction(ByVal connectionString As String)

Using connection As New OracleConnection(connectionString)

connection.Open()

Dim command As OracleCommand = connection.CreateCommand()

Dim transaction As OracleTransaction

' Start a local transaction

transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted)

' Assign transaction object for a pending local transaction

command.Transaction = transaction

Try

command.CommandText = _

"INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')"

command.ExecuteNonQuery()

command.CommandText = _

"INSERT INTO Dept (DeptNo, Dname, Loc) values (60, 'ENGINEERING', 'KANSAS CITY')"

command.ExecuteNonQuery()

transaction.Commit()

Console.WriteLine("Both records are written to database.")

Catch e As Exception

transaction.Rollback()

Console.WriteLine(e.ToString())

Console.WriteLine("Neither record was written to database.")

End Try

End Using

End Sub

適用於

另請參閱