ZZZ Code AI
Report Issues
Suggest Features
Login
Dapper Tools
Chat
Code Explain
Seed Data Generator
Sql Generator
Stored Procedure Generator
Entity to Table Converter
Table to Entity Converter
Sql Injection Detector
More Tools
How to retrieve multiple results returned by a stored procedure in Dapper?
<p>To retrieve multiple results 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>. Then you can read every result by either mapping to an anonymous type or a strongly typed object:</p> <pre><code class="language-csharp">using (var connection = new SqlConnection("connectionString")) { connection.Open(); using (var results = connection.QueryMultiple("MyStoredProcedure", commandType: CommandType.StoredProcedure)) { // Anonymous Type var resultSet1 = results.Read().ToList(); // Strongly Typed Object var resultSet2 = results.Read<ResultType2>().ToList(); } } public class ResultType2 { public int ID { get; set; } public string Name { get; set; } } </code></pre>
Sponsored by
Dapper Plus
This field is required
A text with a minimum of 10 characters is required
Send
Legal & Licensing
Answer generated by AI may produce inaccurate information about code, people, facts, and more.
Advertising Break!
5
seconds left
Did you know...
That you can now sponsor this project on
GitHub
?