Return to Snippet

Revision: 36359
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
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#