FREE AI Dapper Chat: Ask Online Any Entity Framework Questions

<p>To use a stored procedure and retrieve a returned specific column, you have 3 choices:</p>
<ol>
<li>By mapping returned data to an anonymous type and select your column:</li>
</ol>
<pre><code class="language-csharp">using (var connection = new SqlConnection(&quot;connectionString&quot;))
{
    var result = connection.Query(&quot;MyStoredProcedure&quot;, commandType: CommandType.StoredProcedure).ToList();

var specificColumnList = result.Select(x =&gt; x.MyColumn).ToList();
}
</code></pre>
<ol start="3">
<li>By using <a href="https://www.learndapper.com/dapper-query/selecting-multiple-results">QueryMultiple (Multi-Mapping)</a> and read returned data with an anonymous type or strongly typed object:</li>
</ol>
<pre><code class="language-csharp">using (var connection = new SqlConnection(&quot;connectionString&quot;))
{
    using (var multi = connection.QueryMultiple(&quot;MyStoredProcedure&quot;, commandType: CommandType.StoredProcedure))
    {
        var firstResultSet = multi.Read().ToList();
        var specificColumnFromFirstResultSet = firstResultSet.Select(x =&gt; (string)x.MyColumn).ToList();
    }
}
</code></pre>
<div class="alert alert-warning"><p>NOTE: All columns are returned from the stored procedure, not only the desired selected column.</p>
</div>

Advertising Break! 5 seconds left

Did you know...