Search

Wednesday, August 11, 2010

Linq:- LeftOuterJoin

from t in Table0
join t0 in Table1 on t.Id equals t0.EventAttendeeId into t0_join
from t0 in t0_join.DefaultIfEmpty()
join t1 in Table2 on t.AttendeeId equals t1.Id into t1_join
from t1 in t1_join.DefaultIfEmpty()
join t2 in Table3 on t.AttendeeCompanyId equals t2.Id into t2_join
from t2 in t2_join.DefaultIfEmpty()
select new
{


Comments=t0.Comments


}

No comments:

Blog Archive

Contributors