Convert linq to sql with having statement

Asked Jan 02 '18 at 12:25

Active Jan 02 '18 at 12:40

Viewed 36 times

How can I convert this sql to linq

SELECT FK_SubjectId, LectureDays 
FROM tbl_TimeTables 
GROUP BY FK_SubjectId, LectureDays
HAVING(COUNT(Period) < 6)

I couldn't see the answer in the link provided, all i just want is to interpret the group by and having part for my project. Thanks

edited Jan 02 '18 at 12:40

asked Jan 02 '18 at 12:25

Ayodele Timothy

LINQ doesn't have a `having` equivalent. – Gert Arnold Jan 02 '18 at 12:46
Thanks Gert Arnold, that really solved my challenge. – Ayodele Timothy Jan 02 '18 at 13:00

0 Answers0