title: LINQ To Entities Include + Where Method
body: <p>I have NxN table, imagine:</p>
  
  <p>User(id, ...)  &lt;- UserAddresses(id, userId, addressId, enabled, ...) ->  Addresses(id, ...)</p>
  
  <p>UserAddresses contains the FK to user and to address.
  For what I know, the Entity created by the Entity Framework User, contains a collection to UserAddresses. The Address contains a collection to UserAddresses, and a specific UserAddress contains one refenrece to User and to one Address.</p>
  
  <p>Now I want to make the next query by linq.
  For a specific user id, get only the userAddresses with enabled flag setted to true.
  For a specific user id, userAddresses can contain multiple entries but only one is setted for this specific user.</p>
  
  <p>The query I can do is:</p>
  
  <pre><code>context.User.Include( x =&gt; x.UserAddresses )
              .Include( x =&gt; x.UserAddresses.Select(y =&gt; y.Address) )
              .Single( x =&gt; x.id == USER_ID )
  </code></pre>
  
  <p>but what i really want is not to load all UserAddresses for that user... Only the one that contains enabled, setted to TRUE!</p>
  
  <p>Somebody can help me to do this query?</p>