[Solved]-Left Join in Entity Framework 3.5-LINQ,C#

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.

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

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.