title: condition in include in linq to entities
body: <p>I've got this really basic table structure:</p>
  
  <p>Posts</p>
  
  <p>PostXTags</p>
  
  <p>PostTags</p>
  
  <p>There is a 1-n relation between Posts, PostXTags and between PostTags, PostXTags</p>
  
  <p>I need to get all Posts with their tags.</p>
  
  <p>There is a field called type in PostTags and I want to have a filter on it. Every condition in includ encounter this error:</p>
  
  <p>The Include path expression must refer to a navigation property defined on the type. Use dotted paths for reference navigation properties and the Select operator for collection navigation properties.
  Parameter name: path</p>
  
  <pre><code>    Public IQueryable&lt;Post&gt; GetPosts()
      {
          return from p in _db.Posts
                 select p;
      }
  
      var posts = GetPosts().Include(p =&gt; p.PostXTags.Select(pxt =&gt; pxt.PostTag).Where(pt=&gt;pt.Type == 2)).ToList();
  </code></pre>