title: C# - filtering collection based on another collection exception
body: <p>I've searched through numerous examples on how to filter collection based on another collection and I have found an easy way, like so:</p>
  <pre><code>var oShipnotes = await DbContext.ShipNotes.Where(s =&gt; oManageRouteDto.ShipNotes.Any(mr =&gt; mr.Id == s.Id)).ToListAsync();
  </code></pre>
  <p>however it throws an exception that says it cannot be translated to SQL query.</p>
  <p>Could anyone point me the right direction how to solve this?
  Thanks!</p>