title: LEFT JOIN or RIGHT JOIN using LINQ Entity-Framework
body: <p>Trying joining using Linq. 
  What should i use ?  Left join or right join?</p>
  
  <pre><code>     APPLICANT TABLE                         PROFILE TABLE
  APPLICANT_ID|profile_id|Applicant_Name| |profile_id|Applicant_Name  
        1     |    NULL  |  RAY HEAVENS | |    1     | MARK LAPID
        2     |    NULL  |  BEN TULFO   | |    2     | SUPER MAN
        3     |     1    |      NULL    | |    3     | BRANDON KNIGHT
        4     |     2    |      NULL    | |
        5     |     3    |      NULL    | |
  
  DESIRED OUTPUT: 
  
  APPLICANT_ID | Applicant_Name
        1      |   RAY HEAVENS
        2      |   BEN TULFO
        3      |   MARK LAPID
        4      |   SUPERMAN
        5      |   BRANDON KNIGHT
  </code></pre>
  
  <p>This is my code in my controller:</p>
  
  <pre><code>var applicantList = (from a in context.Profiles 
                       join app in context.APPLICANTs
                       on a.PROFILE_ID equals app.Profile_id into output
                       from j in output.DefaultIfEmpty(new APPLICANT())
                       select j ).Take(1000).AsEnumerable();
  
                     applicantdata = applicantList.AsQueryable().OrderBy(v =&gt; v.APPLICANT_ID).ToList();
  
  
              if (applicantdata.Any())
              {
                  Cache.Set("applicants", applicantdata, 30);
              }
          }
          return applicantdata;
  
      }
  </code></pre>
  
  <p>I hope someone can recommend me what to use or what to do.
  Thank you in advance.</p>