FREE AI Dapper Chat: Ask Online Any Entity Framework Questions

<p>To use a stored procedure with input parameters, you need to follow these steps:</p>
<ol>
<li>Create your stored procedure in your database with input parameters:</li>
</ol>
<pre><code class="language-sql">CREATE PROCEDURE MyStoredProcedure
    @InputParam1 INT,
    @InputParam2 INT
AS
BEGIN
    -- Your stored procedure logic here
END
</code></pre>
<ol start="2">
<li>Use a <a href="https://www.learndapper.com/dapper-query">querying</a> or <a href="https://www.learndapper.com/non-query">execute</a> method with an anonymous types for your parameters</li>
</ol>
<pre><code class="language-csharp">using(var connection = new SqlConnection(connectionString))
{
	// Define parameters including your output parameters
	var parameters = new DynamicParameters();
	parameters.Add(&quot;@InputParam1&quot;, inputParam1Value);
	parameters.Add(&quot;@InputParam2&quot;, inputParam2Value);
	
	// Execute the stored procedure
	var result = connection.Query&lt;Customer&gt;(
		&quot;MyStoredProcedure&quot;,
		new { InputParam1 = inputParam1Value, InputParam2 = inputParam2Value},
		commandType: CommandType.StoredProcedure
	).ToList();
}
</code></pre>
<ol start="3">
<li>Or create a <code>DynamicParameters</code> object and add parameter to it.</li>
</ol>
<pre><code class="language-csharp">using(var connection = new SqlConnection(connectionString))
{
	// Define parameters including your output parameters
	var parameters = new DynamicParameters();
	parameters.Add(&quot;@InputParam1&quot;, inputParam1Value);
	parameters.Add(&quot;@InputParam2&quot;, inputParam2Value);
	
	// Execute the stored procedure
	var result = connection.Query&lt;Customer&gt;(
		&quot;MyStoredProcedure&quot;,
		parameters,
		commandType: CommandType.StoredProcedure
	).ToList();
}
</code></pre>

Advertising Break! 5 seconds left

Did you know...