Query: Select.Include.OrderBy ignores the include

[smitpatel]

                    var query2 = context.Set<OrderLine9912>()
                        .Select(o => o.Order)
                        .Include(o => o.Customer)
                        .OrderBy(o => o.Id)
                        .ToList();

If OrderBy is present, we ignore the include, if it is absent then we do include correctly

[maumar]

workaround is to apply Include after the order by

[maumar]

fixed by d527800

[MarcelChirtes]

Something strange happens to me, at first run (request) warning is there, then everything is silent, EF core 2.2.3, contextLifetime and optionsLifetime are scoped, the warning reapers one time once app is restarted.

[ajcvickers]

@MarcelChirtes This is expected. The query compiles once, at which time you see the warning, and is then cached for future calls.

[MarcelChirtes]

@ajcvickers fair point, I assume there's no way to suppress it? Thank you.

[ajcvickers]

@MarcelChirtes Any warning can be suppressed using ConfigureWarnings in the DbContextOptionsBuilder provided by AddDbContext or OnConfiguring.