Преобразовать SQL-запрос с JOIN и сделать отсчет в LINQ

select a.Name, Count(b.Id)
from Table1 a
inner join Table2 a on a.Id = b.Id
Group by  a.Name, b.Id

var result = (from a in Table1IQurable
				join b in Table2IQurable on a.Id equals b.Id 
				select new NewTable
				{
				 Name = a.Name,
				 CountNo = b.count()
				 }).ToList();