Hello everyone, I am trying to figure out how to go about writing a linq query to perform an aggregate like the sql query below:

select d.ID, d.FIRST_NAME, d.LAST_NAME, count(s.id) as design_count
from tbldesigner d inner join
TBLDESIGN s on d.ID = s.DESIGNER_ID
where s.COMPLETED = 1 and d.ACTIVE = 1
group by d.ID, d.FIRST_NAME, d.LAST_NAME
Having COUNT(s.id) > 0

If this is even possible with a linq query could somebody please provide me with an example. Thanks in Advance, Billy