title: Entity Framework filter on foreign key
body: <p>Depot_ID is a foreign key in the database table Address.  In my entity model i noticed that the foreign keys are not listed in the diagram  </p>
  
  <pre><code>var Address = db.ADDRESS.Where(a =&gt; a.Depot_ID == id.Value);
  </code></pre>
  
  <p>This does not work as Depot_id is a foreign key in the Address table.  What do I need to do to filter on this field?</p>