title: Entity Framework - Where Clause
body: <p>Let's say i have a table named User.
  When I use the Entity Framework to get the records i do like this:</p>
  
  <pre><code>var db = new Context();
  var users = db.Users;
  </code></pre>
  
  <p>It return all the users in my table. OK. If i do this:</p>
  
  <pre><code>var fooUsers = db.Users.Where(u =&gt; u.Name == 'foo');
  </code></pre>
  
  <p>It will give me all the users with name 'foo'. OK. My question is:
  The entity framework make a query like:</p>
  
  <pre><code>select * from user where name = 'foo'
  </code></pre>
  
  <p>Or it load all the users and filter them on the server with lambda expression?</p>