title: C# Linq Query with Multiple Joins with an await
body: <p>No matter where I try to add an await in my query I get an intellisence error. 
  Just need to get an await inserted.  This is dotnet core 2.x with EntityFramework core</p>
  
  <pre><code> public async Task&lt;IEnumerable&lt;BalanceItemResource&gt;&gt; GetBalanceItems(int fyId)
   {
   IEnumerable&lt;BalanceItemResource&gt; lQuery = (IEnumerable&lt;BalanceItemResource&gt;)
              from r1 in _context.Requests
              join u1 in _context.Users
              on r1.ApproverId equals u1.Id
              join p1 in _context.Purchases
              on r1.PurchaseId equals p1.Id
              join o1 in _context.OfficeSymbols
              on u1.Office equals o1.Name
              where r1.FYId == fyId
              select new { r1.Id, 
                  p1.PurchaseDate, 
                  officeId = o1.Id, 
                  officeName = o1.Name, 
                  o1.ParentId, o1.Level, 
                  total = r1.SubTotal + r1.Shipping
  
              };
              return lQuery;
  
      }
  </code></pre>