Loading

how to use inner join three tables in linq query and display

how to use inner join three tables in linq query and display

Prabhakar Bharti

Prabhakar Bharti

7y881.NET

how to use inner join three tables in linq query and display data from web gird using mvc4?

1 Reply

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

Puneet Kankar7y ago
1. public ActionResult Index()
2. {
3. List obj = new List();
5. var orderlist = (from a in db.OrderMasters
6. join b in db.Customers on a.CustomerId equals b.Id
7. join c in db.CustomerAddresses on b.Id equals c.CustomerId
8. where a.Status == "Pending"
9. select new
10. {
11. Customername = b.Customername,
12. Phone = b.Phone,
13. OrderId = a.OrderId,
14. OrderDate = a.OrderDate,
15. NoOfItems = a.NoOfItems,
16. Order_amt = a.Order_amt,
17. dis_amt = a.Dis_amt,
18. net_amt = a.Net_amt,
19. status=a.Status,
20. address = c.address,
21. City = c.City,
22. State = c.State,
23. Pin = c.Pin
25. }) ;
26. foreach (var item in orderlist)
27. {
29. CustomerOrder_Result clr = new CustomerOrder_Result();
30. clr.Customername=item.Customername;
31. clr.Phone = item.Phone;
32. clr.OrderId = item.OrderId;
33. clr.OrderDate = item.OrderDate;
34. clr.NoOfItems = item.NoOfItems;
35. clr.Order_amt = item.Order_amt;
36. clr.net_amt = item.net_amt;
37. clr.address = item.address;
38. clr.City = item.City;
39. clr.State = item.State;
40. clr.Pin = item.Pin;
41. clr.status = item.status;
43. obj.Add(clr);
use code like above and create class CustomerOrder_Result with your propertys and add data using loop.
0