How to join 3 entities in linq when using sql?

Guest User

5y650.NET

Hi Team

Can anyone show me how to join 3 entities when using linq in c#?

3 Replies

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

Satya Karki5y ago
Hi, here is another sample. check this
var item=(from pd in dataContext.tblProducts
join od in dataContext.tblOrders on pd.ProductID equals od.ProductID
join ct in dataContext.tblCustomers on od.CustomerID equals ct.CustID
where od.OrderID>50 orderby od.OrderID
select new {
od.OrderID,
pd.ProductID,
pd.Name,
pd.UnitPrice,
od.Quantity,
od.Price,
Customer=ct.Name //define anonymous type Customer
}).ToList();
Check this site there are many examles
https://www.dotnettricks.com/learn/linq/sql-joins-with-csharp-linq
0
Guest User5y ago
Hi Satya
This is my logic, but its joining one table
public IList GetExtractionViewModels(string year, int week)
      {

          ProductionManagementEntities db = new ProductionManagementEntities();


          var scheduleList = (from p in db.ProductionDays
                              join w in db.Weeks // Only Week, Not Models and ProductionDays
                              on p.WeekId equals w.WeekId

                              orderby w.Year ascending
                              orderby w.WeekNum ascending


                              where (w.WeekNum == 5)

                              select new ExtractionViewModel
                              {

                                  Day = p.ProductionDate,
                                  Week = w.WeekNum,

                                  // Model = m.Name,
                                  Year = w.Year

                              }).ToList();
          return scheduleList;
      }
0
Satya Karki5y ago
Hi, you have not shared the table structure. however, it you can do something like this according to your table structure.
from t1 in Table1
join t2 in Table2 on t1.Table2Id equals t2.Id
join t3 in Table3 on t2.Table3Id equals t3.Id
select new
  {
      Name= t1.Name,
      Item= t2.Item,
      Address=t3.Address
  };
0