Query: orderby + include + complex projection doesn't work

[maumar]

copied from one of the comments in #4637

model:

public class Job {

  public Int32 Id { get; set; }
  public String CountryCode { get; set; }
  public String City { get; set; }
  public Boolean IsEnabled { get; set; }
  public virtual Country Country { get; set; }
} 

public class Country {
  public String Code { get; set; }
  public String Name { get; set; }
  public virtual ICollection<Job> Jobs { get; set; } = new List<Job>();
}

query:

var result = await _context.Jobs
   .OrderBy(x => x.Start)
   .Include(x => x.Country)            
   .Where(x => x.IsEnabled)
     .Skip(0).Take(10)
     .Select(x =>
         new {
            Id = x.Id,
            Country = new {
              Code = x.Country.Code,
              Name = x.Country.Name
            }
          })            
        .ToListAsync();

Exception:

The given expression 'new <>f__AnonymousType12(Id = [x].Id, Country = new <>f__AnonymousType22(Code = Property([x], "CountryCode"), Name = [x.Country].Name))' does not contain the searched expression '[x]' in a nested NewExpression with member assignments or a MemberBindingExpression.
Parameter name: fullExpression
at Remotion.Linq.Clauses.ExpressionVisitors.AccessorFindingExpressionVisitor.FindAccessorLambda(Expression searchedExpression, Expression fullExpression, ParameterExpression inputParameter)
at Microsoft.EntityFrameworkCore.Query.EntityQueryModelVisitor.IncludeNavigations(QueryModel queryModel, IReadOnlyCollection1 includeSpecifications) at Microsoft.EntityFrameworkCore.Query.EntityQueryModelVisitor.CreateAsyncQueryExecutor[TResult](QueryModel queryModel) at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddAsyncQuery[TResult](Object cacheKey, Func1 compiler)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteAsyncTResult
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable1.System.Collections.Generic.IAsyncEnumerable.GetEnumerator() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.d__1291.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

The error can be removed in a few ways like:

1. Placing the OrderBy after the Include
2. Remove the Country projection.

[maumar]

The original issue is fixed in the current bits. Subsequent issues that were uncovered were fixed in c88b74f and f022d66