you will find examples of different linq joins here: and loads of other linq examples too.


entity framework in .net 3.5 doesn't offer left join in linq queries. the way to get "joined records" is through navigation property between entities

from here: left outer join in entity data model


you need to use defaultifempty() for an outer join:

from ta in context.test_attempt
join uf in context.user_flag on ta.users.userid equals uf.userid into g
from uf in g.defaultifempty()
select new { ta, uf }

your outer from/select above is unnecessary, just project ta and uf into what you need.

Related Query

More Query from same tag