ASP.NET CORE Using Transactions

最新推荐文章于 2023-11-04 15:02:53 发布

转载最新推荐文章于 2023-11-04 15:02:53 发布 · 248 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/3556610/blog/1615841

文章标签：

#数据库 #python

本文介绍了Entity Framework Core中默认的事务行为及如何通过DbContext.Database API来控制事务的开始、提交和回滚。通过示例展示了如何在一个事务中执行多次SaveChanges操作及查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2019独角兽企业重金招聘Python工程师标准>>>

Default transaction behavior

By default, if the database provider supports transactions, all changes in a single call to SaveChanges() are applied in a transaction. If any of the changes fail, then the transaction is rolled back and none of the changes are applied to the database. This means that SaveChanges() is guaranteed to either completely succeed, or leave the database unmodified if an error occurs.

Controlling transactions

You can use the DbContext.Database API to begin, commit, and rollback transactions. The following example shows two SaveChanges() operations and a LINQ query being executed in a single transaction.

Not all database providers support transactions. Some providers may throw or no-op when transaction APIs are called.

using (var context = new BloggingContext())
        {
            using (var transaction = context.Database.BeginTransaction())
            {
                try
                {
                    context.Blogs.Add(new Blog { Url = "http://blogs.msdn.com/dotnet" });
                    context.SaveChanges();

                    context.Blogs.Add(new Blog { Url = "http://blogs.msdn.com/visualstudio" });
                    context.SaveChanges();

                    var blogs = context.Blogs
                        .OrderBy(b => b.Url)
                        .ToList();

                    // Commit transaction if all commands succeed, transaction will auto-rollback
                    // when disposed if either commands fails
                    transaction.Commit();
                }
                catch (Exception)
                {
                    // TODO: Handle failure
                }
            }
        }

转载于:https://my.oschina.net/u/3556610/blog/1615841