Can't translate OrderBy on a generic method

[TanielianVB]

Hi,
With the following table:

CREATE TABLE public."Things"
(
    "Guid" bigint NOT NULL,
    CONSTRAINT "Things_pkey" PRIMARY KEY ("Guid")
)

The following sample:

    public class EFCoreTestContext : DbContext
    {
        public DbSet<Thing> Things { get; set; }

        public static readonly ILoggerFactory DebugLoggerFactory = LoggerFactory.Create(builder => { builder.AddFilter((category, level) => category == DbLoggerCategory.Database.Command.Name && level == LogLevel.Information).AddConsole(); });

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => optionsBuilder
            .UseLoggerFactory(DebugLoggerFactory)
            .UseNpgsql("Host=localhost;Database=EFCoreTest;Username=test;Password=test");

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder
                .Entity<Thing>(eb =>
                {
                    eb.ToTable("Things");
                    eb.HasKey(e => e.Guid);
                });
        }
    }

    public class Thing
    {
        public long Guid { get; set; }
    }

    public interface IDTO
    {
        long ID { get; set; }
    }

    public class DTO : IDTO
    {
        public long ID { get; set; }
    }

    public class ThingDTO : DTO { }

    class Program
    {
        static IQueryable<TEntity> OrderById<TEntity>(IQueryable<TEntity> query) where TEntity : IEntity => query.OrderBy(e => e.ID);

        static void Main(string[] args)
        {
            using (var db = new EFCoreTestContext())
            {
                var q = (from t in db.Things
                         select new ThingDTO
                         {
                             ID = t.Guid,
                         });

                var r = q.OrderBy(e => e.ID).ToList();

                var r1 = r.ToList();

                Console.WriteLine();

                try
                {
                    var r2 = OrderById(q).ToList();
                }
                catch (Exception ex)
                {
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine(ex.Message);
                }
            }

            Console.ReadKey();
        }
    }

I'm getting this output:

--info
--: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT t."Guid" AS "ID"
      FROM "Things" AS t
      ORDER BY t."Guid"

//The LINQ expression 'DbSet<Thing>
    .OrderBy(t => ((IEntity)new ThingDTO{ ID = t.Guid }
    ).ID)//' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to either AsEnumerable(), AsAsyncEnumerable(), ToList(), or ToListAsync(). See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.

Why?! You were the chosen one! Hahaha

[roji]

Like #1299, this is a generic query translation question which has nothing really to do with Npgsql... Can you please move this to https://github.com/dotnet/efcore? Also, please specify which precise version of EF Core you're using.

[TanielianVB]

Ok. Thank you.

[TanielianVB]

Opened dotnet/efcore#20181