left join in LINQ

Question

Possible Duplicate:
LINQ Inner-Join vs Left-Join

How can i implement left join in LINQ?

plz provide me sample code.

Answer 1

have a look on Left Outer Joins

Answer 2

from e in db.Employees
join d in db.Departments on e.DepartmentId equals d.DepartmentId into MyJoinedTable
from joinedRow in MyJoinedTable.DefaultIfEmpty()
select new
{
    Employee = e,
    Department = d,
};