GroupBy cannot be translated using
Hello I can't for example group data by month using one of class datetime attribute navigation property month
var countryHolidays = await _db.Holidays
.Where(x => x.Country.CountryCode == countryCode && x.HolidayDate.Year == year)
.Include(x => x.Country)
.GroupBy(x => new {
Month = x.HolidayDate.Month
}).ToListAsync();