Inner Join
var empDetails = from emp in objEmp.Employees
join dept in objEmp.Depts on emp.Deptid equalsdept.DeptId
select new
{
emp.EmpName,
emp.Designation,
emp.Location,
dept.DeptName
};
Left Join
var empDetails = from emp in objEmp.Employees
join dept in objEmp.Depts on emp.Deptid equals dept.DeptIdinto empdet
from de in empdet.DefaultIfEmpty()
select new
{
emp.EmpName,
emp.Designation,
emp.Location,
de.DeptName
};