使用嵌套事务范围更新数据库
本文关键字:更新 数据库 范围 嵌套事务 | 更新日期: 2023-09-27 17:53:56
在我的应用程序中,我有两个方法:GetPaymentToDate
和RemovePayment
:
public Payment RemovePayment(int paymentId)
{
Payment payment;
using (var transaction = new TransactionScope(TransactionScopeOption.RequiresNew,
new TransactionOptions { IsolationLevel = IsolationLevel.Serializable }))
{
//some staff
m_staffContext.SaveChanges();
transaction.Complete();
}
return payment;
}
public Payment GetPaymentToDate(DateTime paymentDate)
{
var payment = new Payment
{
//initialize properties
};
using (var transaction = new TransactionScope(TransactionScopeOption.RequiresNew,
new TransactionOptions { IsolationLevel = IsolationLevel.Serializable }))
{
m_staffContext.Payments.Add(payment);
m_staffContext.SaveChanges();
transaction.Complete();
}
return payment;
}
不,我需要实现Update方法。这种方法的逻辑是删除旧的支付,然后创建一个新的支付。因此,如果另一个失败,我想在一个父事务范围和角色回嵌套事务中做到这一点。我要从现有的方法中删除TransactionScopeOption.RequiresNew
选项,并在更新方法中这样写:
public Payment UpdatePayment(int paymentId)
{
Payment newPayment;
using (var transaction = new TransactionScope(TransactionScopeOption.RequiresNew,
new TransactionOptions { IsolationLevel = IsolationLevel.Serializable }))
{
var removedPayment = RemovePayment(paymentId);
var newPayment = GetPaymentToDate(removedPayment.Date);
m_staffContext.SaveChanges();
transaction.Complete();
}
return newPayment;
}
我的代码正确吗?
你不应该调用这些方法,而应该在using块中实现Update Payment中的实际逻辑,如:
using( var transaction = .....)
{
var payment = m_staffContext.Payments.Get(paymentId);
m_staffContext.Payments.Remove(payment);
m_staffContext.Payments.Add(payment);
m_staffContext.SaveChanges();
}
但是为什么你不更新现有的付款。在AddNewPayment方法中,Payment对象的初始化可以在单独的方法中完成,以便重用。
如果这不能解决你的问题,请评论