Linq:- LeftOuterJoin_Count_GroupBy

from dept in Table1
join employee in Table2
on dept.Id equals employee.RoomTypeId

group new{dept,employee} by new
{
dept.Name,
dept.Limit,

employee.RoomTypeId

} into g
where g.Count() > 0
select new
{

d=g.Count(),
g.Key.Name,
g.Key.Limit,

}