The LINQ expression 'DbSet<SalesTable>() .Where(inv => inv.CId == __companyId_0 && inv.FinancialYear == __financialYear_1 && (int)inv.Status == 1 && (int)inv.InvoiceType == 0 || (int)inv.InvoiceType == 10 && inv.Markets != null && inv.Customer != null) .GroupBy(inv => new { MarketId = inv.Markets, CustomerId = inv.Customer }) .Join( inner: DbSet<LedgerTable>(), outerKeySelector: g => g.Key.CustomerId, innerKeySelector: cust => (int?)cust.ID, resultSelector: (g, cust) => new { g = g, cust = cust })' 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 'AsEnumerable', 'AsAsyncEnumerable', 'ToList', or 'ToListAsync'. See https://go.microsoft.com/fwlink/?linkid=2101038 for more information.