ASP.NET MVC5 Linq Query

asif tariq

i have three tables company,payer and cases.Cases have PayerId and CompanyId i want to show data from cases in cases many payer and companies have addedd .

My question is how i show payer name with total cases with total collection with average from linq query

Means if cases have Payer aetna .Please help me?

Thankyou in advance

payor average collection total collection totalcases

aetna $9,004.81 $63,033.64 7

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
1. var res = from c in db.Cases
2. join p in db.Payer on c.payerid equals p.id
3. where c.CompanyId != null
4. group new { , bp } by new { c.payerid } into g
5. let firstpayergroup = g.FirstOrDefault()
6. let case = firstpayergroup.c
7. let pay = firstpayergroup.p
8. let totCollection = g.Sum(x => x.Collection)
9. let avgCollection = g.Average(x => x.Collection),
10. select new payerMinMax
11. {
12. name = pay.payername,
13. avgCollection = avgCollection,
14. totCollection = totCollection
15. };
19. here payerMinMax is a class having properties like name,avgCollection,totCollection

Veerendra Annigere6y ago

var res = from c in db.Cases
join p in db.Payer on c.payerid equals p.id
group c by new{
p.payername
} into g select new {
avgCollection = g.Average(x => x.Collection),
totCollection = g.Sum(x => x.Collection)
payername = g.Key.payername
}