实体框架每次编译后第一次加载非常慢

static void Main(string[] args){
    Stopwatch st=new Stopwatch();
    st.Start();
    new TestDbContext().Set<Table1>.FirstOrDefault();
    st.stop();
    Console.WriteLine("First Time "+st.ElapsedMilliseconds+ " milliseconds");
    st.Reset();
    st.Start();
    new TestDbContext().Set<Table1>.FirstOrDefault();
    st.stop();
    Console.WriteLine("Second Time "+st.ElapsedMilliseconds+ " milliseconds");
}

First Time 15480 milliseconds
Second Time 10 milliseconds

using (MyEntities db = new MyEntities())                
   db.Configuration.AutoDetectChangesEnabled = false; // <----- trick
   db.Configuration.LazyLoadingEnabled = false; // <----- trick
   DateTime Created = DateTime.Now;
   var obj = from tbl in db.MyTable
      where DateTime.Compare(tbl.Created, Created) == 0
      select tbl;
   dataGrid1.ItemsSource = obj.ToList();
   dataGrid.Items.Refresh();
}

protected void Application_Start()
    Start(() =>
        using (EF.DMEntities context = new EF.DMEntities())
            context.DMUsers.FirstOrDefault();
private void Start(Action a)
    a.BeginInvoke(null, null);
}

services.AddDbContext<MyDbContext>(options => ...);
var options = services.BuildServiceProvider()
                      .GetRequiredService<DbContextOptions<MyDbContext>>();
Task.Run(() =>

推荐文章

礼貌的消防车 · qt 中如何加载一张图片，并保存到数据库里以及如何取出图片_qt将图片转成二进制-CSDN博客

4 月前

性感的大象 · VS错误的解决解决：LINK fatal error LNK1000: Internal error during IncrBuildImage-阿里云开发者社区

1 年前

粗眉毛的硬币 · 时间序列分解1 - 知乎

2 年前

成熟的西瓜 · Running Blender python script outside of blender_python_Mangs-DevPress官方社区

2 年前

实体框架每次编译后第一次加载非常慢

6 个回答