how to do left join in lambda

Question

    var item= (from t1 in _dbEntities.PurchaseSales
                join t2 in _dbEntities.ItemTypes on t1.ItemTypeID equals t2.ID
                where t2.ID.Equals(null)
               select t2).ToList();

how to do left join in it

possible duplicate of [LINQ Inner-Join vs Left-Join](http://stackoverflow.com/questions/525194/linq-inner-join-vs-left-join) — Enigmativity, Feb 08 '15 at 10:11

score 0 · Accepted Answer · answered Feb 08 '15 at 10:09

Use DefaultIfEmpty:

var item= (from t1 in _dbEntities.PurchaseSales
                join t2 in _dbEntities.ItemTypes on t1.ItemTypeID equals t2.ID into t
                from l in t.DefaultIfEmpty()
                where l == null
               select t1).ToList();

how to do left join in lambda

1 Answers1