带条件的Linq to SQL预加载

你可以用associateWith来完成。这将起作用:

var options = new DataLoadOptions();
options.AssociateWith<Blog>(b => 
    b.Posts.Where(
        p1 => p1.SomeColumn == b.Posts.Max(p2 => p2. SomeColumn)
    ));

此外,如果要将信息加载到单独的类中,或者可以使用匿名类,则只需执行以下查询:

var query = from b in context.Blogs
            //probably some where you already have
            select new MyBlogs // or with no type in case it is anonymous
            {
                AColumn = b.AColumn, //map any other values
                LatestPost = b.Posts.Where(
                      p1 => p1.SomeColumn == b.Posts.Max(p2 => p2. SomeColumn)
                  )).ToList()
            }

如果您只想要最后一篇文章,那么我怀疑使用惰性加载比用这种方式强制“渴望”加载更有效地查询该文章。