【Devart如何使用数据库事务】

最新推荐文章于 2024-10-02 10:08:12 发布

.net学徒

最新推荐文章于 2024-10-02 10:08:12 发布

阅读量271

点赞数

文章标签： c# java 后端

本文链接：https://blog.csdn.net/puplis/article/details/121524144

版权

Devart 数据库事务 BeginTransaction Commit Rollback

关键词由CSDN通过智能技术生成

Devart如何使用数据库事务

找了很长时间都没找到，无奈翻墙去翻官博，终于找到了，有需要的小伙伴可以参考

//Opening connection
context.Connection.Open();
DEPT department = context.DEPT.Where(d => d.DEPTNO == 10).First();
department.LOC = “TEST”;
//Opening transaction
using (System.Data.Common.DbTransaction transaction
= context.Connection.BeginTransaction())
{
//This call participates in the transaction
context.SaveChanges();
department.DNAME = “TEST”;
//This call also participates in the transaction
context.SaveChanges();
//Replace the flag condition with the one you need
//or remove it and leave only commit part
if(flag)
{
//transaction completed successfully, both calls succeeded
transaction.Commit();
}
else
{
//something is wrong, both calls are rolled back
transaction.Rollback();
}
}