[Linq left outer join] #linq #csharp #entityframework #database

join.cs

from table1 in _repository1
join table2 in _repository2 on table1.column equals table2.column into tmp
where table1.column == null
select new { Object1 = table1, Object2 = tmp.DefaultIfEmpty( ).FirstOrDefault( ) }