How to join multiple table in Linq Query.

Question

Anonymous User · Answer

we are write here twoand  type join multiple table in linq query.1.  var Result1 = db.CUSTOMER.Join(                      db.ORDER,                      cust =andgt; cust.CUST_ID,                      ord =andgt; ord.CUST_ID,                      (cust, ord) =andgt; new                      {                          cust,                          ord                      })                      .Join(db.PRODUCT,                      pro =andgt; pro.ord.PRODUCT_ID,                      p =andgt; p.PRODUCT_ID,                      (pro, p) =andgt; new { pro, p })                      .Select(m =andgt; new                      {                          CustomerName = m.pro.cust.CUST_NAME,                          OrdDate = m.pro.ord.ORD_DATE,                          ProductName = m.p.PRODUCT_NAME                      });2.          var Result2 = from c in db.CUSTOMER                        join o in db.ORDER on c.CUST_ID equals o.CUST_ID                        join p in db.PRODUCT on o.PRODUCT_ID equals p.PRODUCT_ID                        select new                        {                            CustomerName = c.CUST_NAME,                            OrdDate = o.ORD_DATE,                            ProductName = p.PRODUCT_NAME                        };

forum

How to join multiple table in Linq Query.

Anonymous User

Can you answer this question?

1 Answers

Liked By