linq left outer join with visual basic and linqtosql
result = _
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)}
About this entry
You’re currently reading “linq left outer join with visual basic and linqtosql,” an entry on Creator of Cool
- Published:
- April 24, 2008 / 4:30 pm
- Category:
- Programming
No comments yet
Jump to comment form | comment rss [?] | trackback uri [?]