C# EF框架频繁连接性能损耗

最新推荐文章于 2024-02-12 16:00:00 发布

dengshi3066

最新推荐文章于 2024-02-12 16:00:00 发布

阅读量458

点赞数

文章标签： c# 数据库

原文链接：http://www.cnblogs.com/niecx/p/11198517.html

版权

目的

测试EF框架在一次连接中多次保存和多次连接的耗时对比

测试环境

数据库SqlServer 2012 R2
EF框架6.2.0版本

数据库内容

ID	UserName	Password	CreateTime
1	111	123	2019-07-17 12:12:12
2	222	123	2019-07-17 12:12:12

代码

using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace EFConnectTest
{
    class Program
    {
        static void Main(string[] args)
        {
            for(int i=1; i<=10; i++)
            {
                var task1 = Task.Factory.StartNew<long>(Connect1);
                task1.Wait();
                Console.WriteLine(string.Format("第{0}次测试，连接一次的情况下耗时{1}ms", i, task1.Result));

                var task2 = Task.Factory.StartNew<long>(Connect2);
                task2.Wait();
                Console.WriteLine(string.Format("第{0}次测试，连接多次的情况下耗时{1}ms", i, task2.Result));

                Console.WriteLine(string.Format("平均每次连接多耗时{0}ms{1}", (double)(task2.Result - task1.Result) / Count, Environment.NewLine));
            }
            Console.ReadLine();
        }

        /// <summary>
        /// 执行次数
        /// </summary>
        private static int Count = 1000;

        public static long Connect1()
        {
            Stopwatch sw = new Stopwatch();
            sw.Restart();

            using (TestEntities dbContext = new TestEntities())
            {
                var i = 0;
                while (i < Count)
                {
                    var userList = dbContext.User.ToList();
                    foreach (var user in userList)
                    {
                        user.UserName = i.ToString();
                    }
                    i++;
                    dbContext.SaveChanges();
                }
            }
            sw.Stop();
            return sw.ElapsedMilliseconds;
        }

        public static long Connect2()
        {
            Stopwatch sw = new Stopwatch();
            sw.Restart();

            var i = 0;
            while (i < 1000)
            {
                using (TestEntities dbContext = new TestEntities())
                {
                    var userList = dbContext.User.ToList();
                    foreach (var user in userList)
                    {
                        user.UserName = i.ToString();
                    }
                    i++;
                    dbContext.SaveChanges();
                }
            }
            sw.Stop();
            return sw.ElapsedMilliseconds;
        }
    }
}