title: Entity framework (3.5): How to translate a certain LINQ query to eSQL?
body: <p>I have the following LINQ query that I need to translate to Entity SQL /eSQL):</p>
  
  <pre><code>return (ObjectQuery&lt;User&gt;) from user in Users
     where !user.Roles.Any(r =&gt; r.AnIntegerProperty &lt; 0)
     select user;
  </code></pre>
  
  <p>User.Roles is an navigation property to the n:m relation to Roles and there also is a Role.Users navigation property the other way round. There aren't User_Roles or Roles_User Entities available in the model, and I can't add these.</p>
  
  <p>I also can't use the LINQ statement here, because I need to add .OrderBy("it." + propertyname) (comes from another source, can't change that too) later on which is not possible if the ObjectQuery is build with linq.</p>
  
  <p>So how do I translate this to eSQL? And where can I find good eSQL samples? I searched for a whole day until now and must admit that eSQL reference is lousy and there aren't any usable examples around the web.</p>