LINQ：使用INNER JOIN，集团和SUM [英] LINQ: Using INNER JOIN, Group and SUM

问题描述

我想执行使用LINQ和我在做交叉连接和金额计算最接近下面的SQL。我知道必须有一个更好的方式来写，所以我转向堆栈团队寻求帮助。

I am trying to perform the following SQL using LINQ and the closest I got was doing cross joins and sum calculations. I know there has to be a better way to write it so I am turning to the stack team for help.

SELECT T1.Column1, T1.Column2, SUM(T3.Column1) AS Amount
FROM T1
     INNER JOIN T2
     	ON T1.T1ID = T2.T1ID
     INNER JOIN T3
     	ON T2.T3ID = T3.T3ID
GROUP BY T1.Column1, T1.Column2

我一直在试图为以下LINQ code

What I have been trying is the following LINQ code

var qTotal = from T2 in context.T2
             from T3 in context.T3
             where T3.T3ID == T3.T3ID
             group T3 by T2.T1ID into gT2T3
                  from T1 in context.T1
                  where gT2T3.Key.Equals(T1.T1ID)
                  select new { T1.Column1,T1.Column2,Amount = gT2T3.Sum(t => t.Column1)};

我知道必须有一个更好的方式来写，我只是不知道怎么回事，任何帮助将是巨大的！

I know there has to be a better way to write it, I just do not know how, any help would be great!

推荐答案

试试这个：

var total = from T1 in context.T1
            join T2 in context.T2 on T1.T2ID equals T2.T2ID
            join T3 in context.T3 on T2.T3ID equals T3.T3ID
            group T3 by new { T1.Column1, T1.Column2 } into g
            select new { 
                Column1 = T1.Column1, 
                Column2 = T2.Column2, 
                Amount = g.Sum(t3 => t3.Column1) 
            };

这篇关于LINQ：使用INNER JOIN，集团和SUM的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！