How to show calculated field in the index view?

Question

In an MVC project I have the following two tables: CaseData (CaseIdCaseNo ) Invoice (InvoiceId CaseId Amount) CaseId the primary key in table CaseData is a foreign key in table Invoice. There is One to Many relationship between table CaseData and Invoice. What I want to do is to show Sum Total of the field Amount against each record of the table CaseData in the Index view. Please consider that I am using Entity Framework to access data in my project.

Arun Khatri · Answer

Dear Suthish Nair It is not that I do not know how to write the query to get the desired result here is the query which works absolutely well: var invoice = db.tblInvoices .GroupBy(x => x.fldCaseId) .Select(g => new { fldCaseId = g.Key Amount = g.Sum(s => s.fldAmount) }); The problem is I am not able to pass it on to the view through the associated ViewModel so that I get the Amount against each appended row in the index view. Please help.

Arun Khatri · Answer

Thanks!

Suthish Nair · Answer

Use Group By on Caseid or CaseNo. Do not wait for ready made answers try yourself which helps you to learn.