LINQ 分组问题

问题描述

A表AIDName1张三2李四B表BIDMoneyAID121231342查询的结果AIDNameSumMoneyCount1张三522李四41就是以AID分组，查询钱的总数，跟合计的数量

解决方案

解决方案二：
--测试数据准备:CREATETABLE_A(AIDint,Namenvarchar(50))CREATETABLE_B(BIDint,Moneyint,AIDint)insertinto_ASELECT1,'zhangsan'unionSELECT2,'lisi'insertinto_Bselect1,2,1unionselect2,3,1unionselect3,4,2

//LINQ语句:voidMain(){varquery=fromainthis._Asjoinbinthis._Bsona.AIDequalsb.AIDintogselectnew{AID=a.AID,Name=a.Name,SumMoney=g.Sum(t=>t.Money),Count=g.Count()};Console.WriteLine("AIDtNametSumMoneytCount");query.ToList().ForEach(q=>Console.WriteLine("{0}t{1}tt{2}t{3}",q.AID,q.Name,q.SumMoney,q.Count));}/*AIDNameSumMoneyCount1zhangsan522lisi41*/