将选项设置为FbTransaction
本文关键字:FbTransaction 设置 选项 | 更新日期: 2023-09-27 17:58:17
如何将此选项设置为FbTransaction
write
nowait
rec_version
read_committed
在我的代码中执行insert/update-sql语句:
FbConnectionStringBuilder fbConnStr = new FbConnectionStringBuilder();
using (FbConnection fbConn = new FbConnection(fbConnStr))
{
fbConn.Open();
using (FbTransaction fbTran = fbConn.BeginTransaction())
{
using (FbCommand fbCmd = new FbCommand("insert into TEST values (1)", fbConn, fbTran)
{
fbCmd.CommandType = CommandType.Text;
fbCmd.ExecuteNonQuery();
fbCmd.Transaction.Commit();
}
}
fbConn.Close();
}
您可以使用FbTransactionOptions
:
FbTransaction transaction = Connection.BeginTransaction(
FbTransactionOptions.ReadCommitted |
FbTransactionOptions.Write|
FbTransactionOptions.RecVersion|
FbTransactionOptions.NoWait |
);
另请参阅IsolationLevel
:
IsolationLevel.ReadUncommitted
IsolationLevel.ReadCommitted
IsolationLevel.RepeatableRead
IsolationLevel.Serializable
你可以做:
FbTransaction transaction = Connection.BeginTransaction( IsolationLevel.Serializable );