title: How to Join in LINQ using Lambda expressions and get the result in DTO?
body: <p>var query=from e in DataContext.Employees
                join d in DataContext.Dept
                on e.DeptId  equals d.Id
                join o in DataContext.OtherInfo
                on e.Id equals o.EmployeeId 
                where e.EmployeeId==4 
                select new Employee_Dept//DTO
                {
                    EmployeeName=e.Name,
                    DeptName=d.Name
                    EmployeeId=e.ID
                    DeptId=d.Id
                    ContactNo=o.ContactNo
                }</p>
  
  <p>I want to write it using Lambda expressions this is could write - </p>
  
  <pre><code>var query = DataContext.Employees.Join(Dept,e=&gt;e.DeptId,d=&gt;d.Id,(e,d)).Where(e=&gt;e.EmployeeId=4)
  </code></pre>
  
  <p>can anyone help me complete this query. Thanks for your help.</p>