如下是sql语句,求转换成Linq的查询语句
select Home.HomeCategory,Home.HomePhone,Home.HouseID,Home.ApartID,COUNT(*) as PeopleCount from students,Home
where Home.HouseID=students.HouseID
and Home.ApartID=students.ApartID
group by Home.HouseID,Home.ApartID,Home.HomePhone,Home.HomeCategory