How to do inner join, group by and count using linq

Question

This is the output of joining 2 tables by inner join.

I want linq query of joing two table as inner join and group by name from one table and sum of total from another table column as taken snapshot as above.pls help

Possible duplicate of [LINQ: Using INNER JOIN, Group and SUM](https://stackoverflow.com/questions/530925/linq-using-inner-join-group-and-sum) — Nick, Mar 05 '19 at 10:08

score 3 · Accepted Answer · edited May 23 '17 at 12:22

3

Check this post.

var result = (from a in ctx.TableA
             join b in ctx.TableB on a.Id equals b.Id
             group a by a.Name into g
             select new
             {
                Name = g.Key,
                Sum = g.Sum(i => i.Total)
             }).ToList();

edited May 23 '17 at 12:22

Community

1
1

answered Jul 21 '16 at 18:30

neer

4,031
6
20
34

How to do inner join, group by and count using linq

1 Answers1