title: execute custom sql with entity framework4
body: <p>i have to receive workorders from the database, specific for the user.</p>
  
  <p>The filter for all users is different, so one must do all order shipped to UK, ont all to 5 other countries, one does all the high value things, one does al the order which containt > 10 items etc.</p>
  
  <p>So, what i came up with this idea (shoot at it if you have a better one!)</p>
  
  <p>i create a view for each user, and all the views return the same data, but the filter is different.</p>
  
  <p>In ado.net i would do something like this:</p>
  
  <pre><code>string sql = "select * from vwWorkOrders" + userName;
  [rest of the ado.net here]
  </code></pre>
  
  <p>but now i'm using ef4, and i was wondering what is the equivalent of this kind of code.</p>