
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'.

Additional information: Translation of 'Select' which contains grouping parameter without composition is not supported. Select(g => g)' could not be translated. Where(cg => cg.Collection.OrganizationId = _organizationId_0 & _Select_1
