title: Join two tables using Entity Framework
body: <p>Table details:</p>
  
  <p><strong>Login</strong>:</p>
  
  <pre><code> Loginid    username
   -------------------
    1         a
    2         b
    3         c
    4         d
    5         e
  </code></pre>
  
  <p><strong>Personal</strong>:</p>
  
  <pre><code> Loginid    fname   lname
   ------------------------
    1         nitin   kumar
    2         pravin  kumar
  </code></pre>
  
  <p>I want result like this:</p>
  
  <pre><code>  Loginid  username  fname   lname
    --------------------------------
      1        a       nitin   kumar   
      2        b       pravin   kumar
      3        c 
      4        d
      5        e  
  </code></pre>
  
  <p>but when I used join </p>
  
  <pre><code>var balance = (from a in dbContext.login
                 join c in dbContext.Personal on a.loginid equals c.loginid
                 select new { a, c }).ToList();
  </code></pre>
  
  <p>result shows only two rows</p>
  
  <p>How to do it ?</p>
  
  <p>Thanks in advance</p>