How to show calculated field in the index view?

Question

In an MVC project I have the following two tables:

 

CaseData (CaseId,CaseNo )

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.