FREE AI Dapper Chat: Ask Online Any Entity Framework Questions

<p>To retrieve multiple rows returned by a <a href="https://www.learndapper.com/stored-procedures">stored procedure</a>, you need to specify the stored procedure name in the command text and specify the command type to <code>CommandType.StoredProcedure</code>.</p>
<ol>
<li>First, create your stored procedure:</li>
</ol>
<pre><code class="language-sql">CREATE PROCEDURE MyStoredProcedure
AS
BEGIN
    SELECT * FROM Customer
END
</code></pre>
<ol start="2">
<li>Map returned data to an anonymous type or a strongly typed object:</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();
}
</code></pre>
<pre><code class="language-csharp">public class Customer
{
    public int CustomerID { get; set; }
    public string Name { get; set; }
	
    // Add other properties as needed, to match all columns returned by the stored procedure
}
	
using (var connection = new SqlConnection(&quot;connectionString&quot;))
{
    var result = connection.Query&lt;Customer&gt;(&quot;MyStoredProcedure&quot;, commandType: CommandType.StoredProcedure).ToList();
}
</code></pre>

Advertising Break! 5 seconds left

Did you know...