介绍一个简单的linq查询
Customer表:(Username )
Order表:(Orderid ,Username)
OrderDetails表:(Orderid,Bookid,BookCount,BookPrices)
var tc= from c in dt.Customer
where c.Username.euals("张三")
select new
{
TotalSales=c..Order.Sum(o=>
o.OrderDetails.sum(od=>od.BookCount*od.BookPrices)
)
};
检索张三用户购买的所有图书的金额