参考http://www.cnblogs.com/aspnet2008/archive/2008/12/23/1358494.html
多表查询数据
from c in Customers
join p in Purchases
on c.ID equals p.CustomerID
group p.Price by new
{
p.Date.Year,
c.Name
}
into salesByYear
orderby salesByYear.Key.Year descending
select new
{
TotalPrice= salesByYear.Sum(),
Year=salesByYear.Key.Year,
Name=salesByYear.Key.Name
}
这个还是需要多注意一下。