linq left outer join with visual basic and linqtosql
Thursday, April 24th, 2008result = _
From master In dc.Masters _
Where (master.name.Contains(txtSearch.Text) _
Group Join detail In dc.details On master Equals detail.Master Into both = Group _
From b In both.DefaultIfEmpty _
Select New With {.master = master, .detail = If(master.Details.Count = 0, New Detail, b)}