Revision: 36359
Updated Code
at November 21, 2010 02:13 by housecor
Updated Code
var allTeamMembers = from t in db.TeamMembers join ct in db.CaseTeamMembers on t.TeamMemberID equals ct.TeamMemberID into ctm from ct in ctm.DefaultIfEmpty() select new { CaseID = ct.CaseID == null ? 0 : ct.CaseID, t.TeamMemberID, CaseTeamMemberID = ct.CaseTeamMemberID == null ? 0 : ct.CaseTeamMemberID, t.Name, Photo = t.Photo ?? "default.gif" };
Revision: 36358
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at November 21, 2010 02:11 by housecor
Initial Code
var allTeamMembers = from t in db.TeamMembers join ct in db.CaseTeamMembers on t.TeamMemberID equals ct.TeamMemberID into ctm from ct in ctm.DefaultIfEmpty() select new { CaseID = ct.CaseID == null ? 0 : ct.CaseID, t.TeamMemberID, CaseTeamMemberID = ct.CaseTeamMemberID == null ? 0 : ct.CaseTeamMemberID, t.Name, Photo = t.Photo ?? "default.gif" };
Initial URL
http://www.hookedonlinq.com/OuterJoinSample.ashx
Initial Description
NOTE: When you do an outer join, every column selected that could be null from the join must have a ternary operator in the select statement.
Initial Title
LINQ outer join
Initial Tags
Initial Language
C#