how to apply joins in linq query

Question

Hi Friends Please help me for below query: how to apply join ???like i want this type output query select * from CostCentre1 as c left Outer join Master as m on m.code=c.code my query : return Json(context.CostCentre1.Where(x => x.Name.Contains(term)).Select(s => s.Name).ToArray() JsonRequestBehavior.AllowGet);

Ananth Padmanabham vemula · Answer

Hi dipti Check two points in your code... 1. c.Code and m.Code are belongs to same datatype or not 2. term has to be a string type

dipti prasad · Answer

Hi Sir This is my linq code but not working: public JsonResult AutocompleteProfitCenter(string term) { Dal.WEBERPEntities context = new Dal.WEBERPEntities(); var result = (from c in ctx. CostCentre1 join m in ctx.Master1 on c.Code equals m.Code where c.Name.Contains(term) select new { Name = c.Name }); return Json(result JsonRequestBehavior.AllowGet); }

Saber Shaikh · Answer

This Is 100% work DataContext db = new DataContext(); var Query = from A in db.TblA join B in db.TblB on A.Id equals B.ID where (A.ID == 20) select new { A.ID B .Name A.DateTimeInfo };

Munesh Sharma · Answer

use this dipti prasad from c in CostCentre1 join m in Master on c. code equals m. code into m_join from m in m_join.DefaultIfEmpty() select new { c.code m.code c.otherthing }