8,497
社区成员
发帖
与我相关
我的任务
分享
var query = from p in db.PaymentRequests
join payees in db.Payees into details
join q in db.PaymentRequestsDeatils into details
select new
{
PayNO = p.PayId,
PayeeName = payees.PayeeName,
LstContractNO = details.Select(g=>g.ContractNO),
LstDetails = details.Select(g=>g.PaymentContent),
LstPayMoney = details.Select(g=>g.PayMoney),
TotalMoney = details.Sum(g=>g.PayMoney)
}
var query = from p in db.PaymentRequests
select new
{
PayNO = p.PayId,
PayeeName = p.Payees.PayeeName,
LstContractNO = p.PaymentRequestsDetails.Select(g=>g.ContractNO),
LstDetails = p.PaymentRequestsDetails.Select(g=>g.PaymentContent),
LstPayMoney = p.PaymentRequestsDetails.Select(g=>g.PayMoney),
TotalMoney = p.PaymentRequestsDetails.Sum(g=>g.PayMoney)
}
如果没有主外键其实就是弄一些join而已,下面的select大致差不多。