title: Entity Framework ToListAsync() with Select()
body: <p>I have the following ActionResult in my controller</p>
  
  <pre><code>public async Task&lt;ActionResult&gt; NewTickets()
  {
      // Show tickets for all divisions a agent is in
  
      var user = "abcdefg";
      var company = "company1";
  
      var tickets = (from a in db2.Ticket
          join c in db2.Division on a.DivisionId equals c.DivisionId
          join dp in db2.DivisionParticipator on c.DivisionId equals dp.DivisionId
          where c.CompanyId == company.CompanyId &amp;&amp; a.Status == "New" &amp;&amp; dp.ApplicationUserId == user.Id
          select new
          {
              Id = a.Id,
              DivisionId = a.DivisionId,
              Name = a.Name,
              TicketDate = a.TicketDate,
              NewPosts = a.NewPosts,
              Status = a.Status,
              Type = a.Type
           })
           .ToList().Select(x =&gt; new Ticket
           {
               Id = x.Id,
               DivisionId = x.DivisionId,
               Name = x.Name,
               TicketDate = x.TicketDate,
               NewPosts = x.NewPosts,
               Status = x.Status,
               Type = x.Type
            });            
  
      return PartialView(tickets.ToList());
  }
  </code></pre>
  
  <p>What i want to achieve is running this async, however if adding the <code>ToListAsync()</code>before <code>Select()</code>the <code>Select()</code> method becomes unavailable. The same goes for the <code>return PartialView(tickets.ToList())</code>.</p>
  
  <p>I'm fairly new to working with async but reading about it's advantages I have been convering regular ActionResult methods with async ones. This has been going fine so far with easier LINQ-based queries. However for this ActionResult-method the query is a bit more advanced and the syntax/way to implement it seems to differ.</p>
  
  <p>Any help to send me in the right direction would be greatly appreciated!</p>