title: LINQ to Entities, how to return all records from the Parent table?
body: <p>I am unable to select all the records from the parent table using Linq to Entities.</p>
  
  <p>This is a simple DB design (image below):</p>
  
  <p><strike><a href="http://www.thinkboard.com/myimages/tablerelation.jpg" rel="nofollow noreferrer">Image Link</a></strike> (Dead Link)</p>
  
  <p>This is the exact output I want using Linq to Entities or Linq to SQL (image below):</p>
  
  <p><strike><a href="http://www.thinkboard.com/myimages/sqlresults.jpg" rel="nofollow noreferrer">Image Link</a></strike> (Dead Link)</p>
  
  <p>When I use Linq to Entities or Linq To Sql, I can only get the records from the child table that has a foreign key relation. I am not able to get the null values as shown above.</p>
  
  <p>I want to have the null values show just like when you use <code>left outer join</code>.</p>
  
  <p>Thanks for any help.</p>