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();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)