EF批量更新优化

最新推荐文章于 2024-07-21 21:47:47 发布

ItDotNet

最新推荐文章于 2024-07-21 21:47:47 发布

阅读量6k

点赞数

分类专栏： EF

本文链接：https://blog.csdn.net/ItDotNet/article/details/53978208

版权

EF 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

未优化修改：

static void Main(string[] args)
        {
            DateTime startDateTime = DateTime.Now;
            using (studyEntities study = new studyEntities())
            {
                //study.Configuration.AutoDetectChangesEnabled = false;
                var users = study.Users.Where(x=>x.Id>0);
                foreach (var item in users)
                {
                    item.Name = "你我他";
                }
                DateTime insetLocalDateTime = DateTime.Now;
                TimeSpan local = insetLocalDateTime - startDateTime;
                Console.WriteLine("数量" + 10000 + " 本地添加到数据上下文耗时 " + local.TotalMinutes + " 分钟 = " + local.TotalSeconds + " 秒");
                study.SaveChanges();
                DateTime insetDataDateTime = DateTime.Now;
                TimeSpan data = insetDataDateTime - insetLocalDateTime;
                Console.WriteLine("数量" + 10000 + " 数据库添加完成耗时" + data.TotalMinutes + " 分钟 = " + data.TotalSeconds + " 秒");
            }
        }

优化在添加到数据上下文，关闭 AutoDetectChangesEnabled ，提交之前开启 AutoDetectChangesEnabled

static void Main(string[] args)
        {
            DateTime startDateTime = DateTime.Now;
            using (studyEntities study = new studyEntities())
            {
                study.Configuration.AutoDetectChangesEnabled = false;
                var users = study.Users.Where(x=>x.Id>0);
                foreach (var item in users)
                {
                    item.Name = "你我他2";
                }
                DateTime insetLocalDateTime = DateTime.Now;
                TimeSpan local = insetLocalDateTime - startDateTime;
                Console.WriteLine("数量" + 10000 + " 本地添加到数据上下文耗时 " + local.TotalMinutes + " 分钟 = " + local.TotalSeconds + " 秒");
                study.Configuration.AutoDetectChangesEnabled = true;
                study.SaveChanges();
                DateTime insetDataDateTime = DateTime.Now;
                TimeSpan data = insetDataDateTime - insetLocalDateTime;
                Console.WriteLine("数量" + 10000 + " 数据库添加完成耗时" + data.TotalMinutes + " 分钟 = " + data.TotalSeconds + " 秒");
            }
        }