懒加载回填数据的机制是什么?

[misgw]

在使用WithTempQuery()后使用Include方法后,生成的sql已经把数据查询出来了,但是没有回写实体

[2881099]

WithTempQuery 和懒加载关系不大，给代码看看

[misgw]

查询代码
目的: 查询用户订单集合中Id最大的订单

var data = _userRepository
    .Where(p => p.IsActive)
    .WithTempQuery(p => new User { Id = p.Id, OrderId = p.OrderId })
    .GroupBy(p => new { p.OrderId })
    .WithTempQuery(p => new User { Id = p.Max(p.Value.Id), OrderId = p.Key.OrderId })
    .Include(p => p.Order)
    .OrderByDescending(p => p.OrderId)
    .ToListAsync();

实体代码

public class User
{
    [Column(IsPrimary = true, IsIdentity = true)]
    public long Id { get; set; }

    public long OrderId { get; set; }

    ...

    public virtual Order Order { get; set; }
}

public class Order
{
    [Column(IsPrimary = true, IsIdentity = true)]
    public long Id { get; set; }

    ...
}

[2881099]

fsql.Select<User>()
    .Where(p => p.IsActive)
    .GroupBy(p => new { p.OrderId })
    .WithTempQuery(p => new { Id = p.Max(p.Value.Id), OrderId = p.Key.OrderId })
    .From<Order>()
    .InnerJoin((a, b) => a.OrderId == b.Id)
    .OrderByDescending((a, b) => a.OrderId)
    .ToListAsync((a, b) => new User { Id = a.Id, OrderId = a.OrderId, Order = b } );

[misgw]

不好意思,没表述清楚
Order也存在需要懒加载的数据,
实际代码是下面这种情况, 存在嵌套,以及OneToMany

var data = _userRepository
    .Where(p => p.IsActive)
    .WithTempQuery(p => new User { Id = p.Id, OrderId = p.OrderId })
    .GroupBy(p => new { p.OrderId })
    .WithTempQuery(p => new User { Id = p.Max(p.Value.Id), OrderId = p.Key.OrderId })
    .Include(p => p.Order)
    .Include(p => p.Order.Extra)
    .IncludeMany(p => p.Order.Details.Where(c => c.OrderId == p.Order.Id))
    .OrderByDescending(p => p.OrderId)
    .ToListAsync();

[misgw]

没转过弯,试了实际可以了