title: Entity Framework 6: filter a table
body: <p>I', approaching to EF6. I have understood that, if I want a single record, I can use the <code>First()</code> method (usable also like a "get", I think).</p>
  
  <p>But what if I want a collection of records from my table? I mean, if the result of query can have a cardinality from 0 to N... what have I to do?</p>
  
  <p>Silly Example:</p>
  
  <p>Name table: SomeTable</p>
  
  <pre><code>ID    NAME    SOMEATTR
  1      A       YELLOW
  2      B        RED
  3      C       YELLOW
  4      D       YELLOW
  5      E        BLUE
  </code></pre>
  
  <p>...</p>
  
  <p>How can I get all the records where someAttr is "yellow"?</p>