title: Entity Framework 6 search on foreign keyed table
body: <p>We have a Customer Retuns database with two tables in it: &quot;Returns&quot; and &quot;Cause&quot;.
  <a href="https://i.stack.imgur.com/GsPLM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GsPLM.png" alt="enter image description here" /></a></p>
  <p>The Returns table has customer returns in it, while cause is a list of reasons for the return - A Return can have multiple Causes. What we are trying to do is a search on the Returns table along the lines of &quot;Description.Contains('Table') and Returns.Cause.Contains('Wrong Colour')&quot;, Is there a neat way to perform this search or do I have retrieve &quot;everything&quot; from the tables and filter them out in multiple stages?</p>