求教sql 转 linq to ef 的问题,高手帮帮忙...

[china_sqzl]

select a.purchase_code,a.staff_id,sum(b.price)
from purchase a,purchase_product b where a.purchase_id=b.purchase_id
group by a.purchase_code,a.staff_id

转成 linq to ef

from a in _dbo.Purchases
from b in _dbo.PurchaseProducts
where a.Purchase_ID == b.Purchase_ID
.
.
.

后面的groupby 和select 中的sum 不会写,哪位高手帮帮忙啊,在线等啊...

[licai1210]

from a in _dbo.Purchases
from b in _dbo.PurchaseProducts
where a.Purchase_ID == b.Purchase_ID
group a by a.purchase_code,a.staff_id into g
select new
{
purchase_code=a.purchase_code,
staff_id=a.staff_id,
sum=g.sum(b.price)
}

[licai1210]

http://developer.51cto.com/art/200909/150348.htm

[licai1210]

from a in _dbo.Purchases
from b in _dbo.PurchaseProducts
where a.Purchase_ID == b.Purchase_ID
group a by new{purchase_code=a.purchase_code,staff_id=a.staff_id} into g
select new
{
purchase_code=a.purchase_code,
staff_id=a.staff_id,
sum=g.sum(g=>b.price)
}

[china_sqzl]

[Quote=引用 3 楼 的回复:]

from a in _dbo.Purchases
from b in _dbo.PurchaseProducts
where a.Purchase_ID == b.Purchase_ID
group a by new{purchase_code=a.purchase_code,staff_id=a.staff_id} into g
select new
{
purchase_code……
[/Quote]

非常感谢!