title: How can I use Left join in linq that we use in sql?
body: <p>How can I use Left join in Linq that I write SQL query?</p>
  
  <pre><code>select 
      p.Name, p.Family,
      E.EmployTypecode, E.employtypeName, E.EmplytyppeTye 
  from 
      personnel as p
  left join 
      Employee as E on E.EmployTypecode = p.EmployTypecode 
  </code></pre>