EF延迟加载详解

最新推荐文章于 2024-05-12 21:12:42 发布

武功山上捡瓶子

最新推荐文章于 2024-05-12 21:12:42 发布

阅读量328

点赞数

分类专栏：职聊NET 文章标签：数据库服务器 asp.net 职聊NET

本文链接：https://blog.csdn.net/qq_36799389/article/details/132050694

版权

职聊NET 专栏收录该内容

57 篇文章 1 订阅

订阅专栏

EF延迟加载详解

一、默认情况下，导航属性是延迟查询；

//条件是virtaul属性+默认配置
using (JDDbContext dbContext = new JDDbContext())
{
    var companyList = dbContext.Set<Company>().Where(c => c.Id < 20);
    foreach (var company in companyList)//只差company
    {
        Console.WriteLine(company.Name);
        foreach (var user in company.Users)//再去查用户
        {
            Console.WriteLine(user.Name);
        }
    }
}

二、关闭延迟加载，子表数据就没了

using (JDDbContext dbContext = new JDDbContext())
{
    dbContext.Configuration.LazyLoadingEnabled = false;//关闭延迟查询
    var companyList = dbContext.Set<Company>().Where(c => c.Id < 20);
    foreach (var company in companyList)//只差company
    {
        Console.WriteLine(company.Name);
        foreach (var user in company.Users)//再去查用户
        {
            Console.WriteLine(user.Name);
        }
    }
}

三、预先加载 Include 查询主表时就把子表数据一次性查出来（其实自己join也可以的）

using (JDDbContext dbContext = new JDDbContext())
{
    dbContext.Configuration.LazyLoadingEnabled = false;//是否关闭无所谓
    var companyList = dbContext.Set<Company>().Include("Users").Where(c => c.Id < 20);
    foreach (var company in companyList)//只差company
    {
        Console.WriteLine(company.Name);
        foreach (var user in company.Users)//再去查用户
        {
            Console.WriteLine(user.Name);
        }
    }
}

四、关闭延迟查询后,如果需要子表数据，可以显示加载

using (JDDbContext dbContext = new JDDbContext())
{
    dbContext.Configuration.LazyLoadingEnabled = false;//关闭延迟查询
    var companyList = dbContext.Set<Company>().Where(c => c.Id < 20);
    foreach (var company in companyList)//只查company
    {
        Console.WriteLine(company.Name);
        dbContext.Entry<Company>(company).Collection(c => c.Users).Load();
        //dbContext.Entry<Company>(company).Reference(c => c.Users).Load();
        foreach (var user in company.Users)//再去查用户
        {
            Console.WriteLine(user.Name);
        }
    }
}