c# - 只返回计数大于 X 的对象

Question

我不确定如何使用 Entity Framework 执行此操作。我得到以下信息:

return this.enrollments
                .Where(e => e.em_enrolled == false && e.em_result < _settings.PassMark)
                .GroupBy(e => e.em_subject_id)
                .Select(e => e.em_subject_id)
                .ToList();

我如何只检索出现 x 次的记录。

Answer 1

你的意思是包含 x 个或更多项的组？

return this.enrollments
                .Where(e => e.em_enrolled == false && e.em_result < _settings.PassMark)
                .GroupBy(e => e.em_subject_id)
                .Where(g => g.Count() >= x)
                .Select(g => g.Key)
                .ToList();