title: Left outer join in linq
body: <p>I have the following query but i have no idea on how to do a left outer join on table 1.</p>
  
  <pre><code>var query = (from r in table1
               join f in table2
                   on r.ID equals f.ID
               select new
               {     
                   r.ID, 
                   r.FirstName,
                   r.LastName,
                   FirstNameOnRecord = 
                       (f != null ? f.FirstName : string.Empty),
                   LastNameOnRecord = 
                       (f != null ? f.LastName : string.Empty),
                   NameChanged = 
                       (f != null 
                           ? (f.FirstName.CompareTo(r.FirstName) == 0 
                               &amp;&amp; f.LastName.CompareTo(r.LastName) == 0) 
                           : false)
               }).ToList();
  </code></pre>