title: EF 4.1 code-first: How to select an entity with it's collection-property's count
body: <p>I have an entity named <em><code>Tag</code></em> with a navigation property (collection) named <em><code>Articles</code></em>. The <em><code>Tag</code></em> has a ignored-property named <em><code>ArticleCount</code></em> that used to save tha associated <em><code>Article</code></em> s count (just in run-time and to use in views- ignored against the DB). See:</p>
  
  <pre><code>public class Tag{
  
      public int Id { get; set; }
  
      public int Title { get; set; }
  
      public virtual ICollection&lt;Article&gt; Articles { get; set; }
  
      [NotMapped]
      public int ArticleCount { get; set; }
  
  }
  </code></pre>
  
  <p>How can I select all <em><code>Tag</code></em> s (or one) with it's <em><code>ArticleCount</code></em> in <strong>ONE</strong> query against the dataBase -in <strong>entity framework 4.1 code-first, with lambda expressions</strong> please?</p>