How to join 3 entities in linq when using sql?

Question

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

Satya Karki · Answer

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

Satya Karki · Answer

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 };

Guest User · Answer

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; }

How to join 3 entities in linq when using sql?

Answers (3)