title: Joining returning null if one of the column is null
body: <p>I have two tables, <code>Parts</code> and <code>Blob</code>.</p>
  
  <p><strong>db.Parts</strong></p>
  
  <pre><code>Id   name   x    y   z  partimageid
  -----------------------------------
  1    bolt   30   40  5       4 
  2    screw  33   4   6     null
  </code></pre>
  
  <p><strong>db.Blob</strong></p>
  
  <pre><code>Id   content      name
  ------------------------------
  4    fsbfvb       picture.png
  </code></pre>
  
  <p>How can I get a part detail with image content?</p>
  
  <p>Currently I am doing like this:</p>
  
  <pre><code>public async Task&lt;IHttpActionResult&gt; GetPart(int id)
  {    
      var result = from part in db.Parts
                   join image in db.Blob on part.PartImageId equals image.Id
                   where part.Id == id
                   select new { part, image.Content};
      return Ok(result);
  }
  </code></pre>
  
  <p>It's working, but if image is not there - part also coming as null. what am I doing wrong here?</p>