Breaking News: Grepper is joining You.com. Read the official announcement!

Entity_Framework Left Join

Strange Sloth answered on July 8, 2022 Popularity 8/10 Helpfulness 2/10

answer Entity_Framework Left Join

related LEFT JOIN entity framework

Entity_Framework Left Join

Comment

using (ConName db = new ConName ())
   {
   var data = (from p in db.ProductMasters join sr in db.StoreMasters
     on p.StoreId equals sr.StoreId into lJ
     from res in lJ.DefaultIfEmpty()
     select new
     {
      ProductID = p.ProductId,
      ProductName = p.ProductName,
      StoreID=res.StoreId,
      StoreName=res.StoreName,
      StoreEmail=res.EmailId
     }).ToList();
foreach (var products in data)
 {
   Console.WriteLine(products.ProductID+"\t"+products.ProductName+"\t\t" + products.StoreName+"\t"+products.StoreEmail+"\n");
 }

Popularity 8/10 Helpfulness 2/10 Language whatever

Source: www.educba.com

Tags: left-join whatever

Link to this answer
Share Copy Link

Contributed on Jan 27 2023

Strange Sloth

0 Answers Avg Quality 2/10

Closely Related Answers

LEFT JOIN entity framework

Comment

var qry = Foo.GroupJoin(
          Bar, 
          foo => foo.Foo_Id,
          bar => bar.Foo_Id,
          (x,y) => new { Foo = x, Bars = y })
       .SelectMany(
           x => x.Bars.DefaultIfEmpty(),
           (x,y) => new { Foo=x.Foo, Bar=y});

Popularity 9/10 Helpfulness 4/10 Language whatever

Source: stackoverflow.com

Tags: entity-framework enti

Link to this answer
Share Copy Link