how to apply joins in linq query

dipti prasad

11y1.3kLINQ

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

4 Replies

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

Ananth Padmanabham vemula11y ago
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 prasad11y ago
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 Shaikh11y ago
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 Sharma11y ago
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
}