Linq Query according to companyID

Question

i want to show from link query result in view how we write link query please help me and give solid solution

My table with cases and payer and datashow according to companyID.

 

 

 

I want to show result like this

 

please help me.Thankyou