.Include() 影响查询的结果数

Question

>我有非常简单的查询，它返回Order，但是当我对许多Includes和ThenInclude执行相同的查询时，查询返回 0 个结果而不是 1

var a = _context
        .Orders
        .FirstOrDefault(x => x.Id == OrderId);
var b = _context
        .Orders
        .OrdersFullInclude()
        .FirstOrDefault(x => x.Id == OrderId);

其中OrdersFullInclude() =

public static IQueryable<Order> OrdersFullInclude(this IQueryable<Order> input)
{
    return  input
           .Include(x => x.StatusesHistory)
           .Include(x => x.File)
           .Include(x => x.SomeData)
           .ThenInclude(x => x.SomeDeeperLevel)
           .Include(x => x.Company)
           .Include(x => x.Customer)
           .Include(x => x.Insurance)
           .ThenInclude(x => x.InsuranceSomething); 
}

为什么？

Answer 1

通过调用Include，您将结果与其他一些表联接，并且似乎并非所有联接的表都具有与第一个结果集中的记录相关的记录，因此它不返回任何结果。