title: c# Dapper - using linq on QueryAsync method
body: <p>Why can't I use .select on a queryAsync when it works fine on Query?
  For example, here the .select yells at me telling me it cant resolve the symbol &quot;select&quot;:</p>
  <pre><code>var result = await sqlConnection.QueryAsync&lt;Product&gt;(procedure,
                              commandType: CommandType.StoredProcedure).Select(p =&gt; new Product
                          {
                              Code= (string)p.fldCode,
                              Name=(string)p.fldName
                              });
  </code></pre>
  <p>but as soon as i change to Query, it doesn't yell anymore. if anything it has trouble resolving the fldCode columns from the sp:</p>
  <pre><code> var result = sqlConnection.Query&lt;Product&gt;(procedure,
                                  commandType: CommandType.StoredProcedure).Select(p =&gt; new Product
                              {
                                  Code= (string)p.fldCode,
                                  Name=(string)p.fldName
                                  });
  </code></pre>
  <p>why is this?</p>
  <p>I asked a previous question here <a href="https://stackoverflow.com/questions/63671025/c-sharp-dapper-mapping-columns-to-entity-properties-cannot-resolve-symbol-se">C# Dapper mapping columns to entity properties - &quot;Cannot resolve symbol &#39;Select&#39;&quot;</a></p>