I am using asp.net mvc 5 , Entity framework 5,
i have following tables:
1. orderid customerid
1 2
2 3
3 1
orderid productname quantity
1 A 10
1 B 15
1 C 20
i.e I want to make a report like following:
Total Quantity per customer:
total total total
Qty for Qty for Qty for
productname customer1 customer2 customer3
1.......................2.............3.............33
2.......................3.............2.............24
3.......................4.............22............34
i am using asp.net mvc 5, entity framework 5 ,linq