score:0

you will find examples of different linq joins here: http://code.msdn.microsoft.com/linq-join-operators-dabef4e9 and loads of other linq examples too.

score:0

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 asp.net

score:1

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