日期:2014-05-20 浏览次数:21058 次
var result = from a in data.A
from b in data.B
where a.AID == b.AID
group new { a = a, b = b } by new { a.AID, a.Name } into g
select new
{
Aid = g.Key.AID,
Name = g.Key.Name,
Count = g.Count(),
SumMoney = g.Sum(x => x.b.Money)
};
------解决方案--------------------
--测试数据准备:
CREATE TABLE _A
(
AID int,
Name nvarchar(50)
)
CREATE TABLE _B
(
BID int,
Money int,
AID int
)
insert into _A SELECT 1,'zhangsan' union SELECT 2,'lisi'
insert into _B select 1,2,1 union
select 2,3,1 union
select 3,4,2