title: Make EFCore more performant
body: <p>so here is my looong query and the problem is that I need every include I'm making and it's slow, but how can I make it better?</p>
  <pre><code>await _context.Set&lt;ProductEntity&gt;()
                  .Include(i =&gt; i.Media)
                  .Include(i =&gt; i.Categories)
                  .Include(i =&gt; i.Reports)
                  .Include(i =&gt; i.Bookmarks)
                  .Include(i =&gt; i.Votes)
                  .Include(i =&gt; i.User).ThenInclude(x =&gt; x.Media)
                  .Include(i =&gt; i.User).ThenInclude(x =&gt; x.Categories)
                  .Include(i =&gt; i.Forms)!.ThenInclude(x =&gt; x.FormField)
                  .Include(i =&gt; i.Comments)!.ThenInclude(x =&gt; x.LikeComments)
                  .Include(i =&gt; i.Teams)!.ThenInclude(x =&gt; x.User).ThenInclude(x =&gt; x.Media)
                  .Include(i =&gt; i.VoteFields)!.ThenInclude(x =&gt; x.Votes)
                  .AsNoTracking()
  </code></pre>
  <p>I got a tip that Select is better than Include, but I do'nt realy know how can I do that.</p>