title: Merging Multiple related Queries in .Net Core
body: <p>I want to implement a Page where each Category have its related articles, I have implemented it as follow:</p>
  
  <pre><code>  ArticlesHomeViewModel articles  = new ArticlesHomeViewModel
    { 
      category1 = db.Articles.Include(o =&gt; o.Category).Where(m =&gt; m.category == "Category One Name").limit(4),
      category2 = db.Articles.Include(o =&gt; o.Category).Where(m =&gt; m.category == "Category two Name").limit(4),
      category3 = db.Articles.Include(o =&gt; o.Category).Where(m =&gt; m.category == "Category Three Name").limit(4),
      category4 = db.Articles.Include(o =&gt; o.Category).Where(m =&gt; m.category == "Category Four Name").limit(4),
    }
  </code></pre>
  
  <p>And I want to merge them into one query to be able to loop against them in the view because I don't know how many categories that could be in the system. </p>