FREE AI Dapper Chat: Ask Online Any Entity Framework Questions

<p>To use a stored procedure with an output parameter, you need to follow these steps:</p>
<ol>
<li>Create your stored procedure in your database with an output parameter:</li>
</ol>
<pre><code class="language-sql">CREATE PROCEDURE MyStoredProcedure
    @InputParam1 INT,
    @OutputParam2 INT OUTPUT
AS
BEGIN
    -- Your stored procedure logic here
END
</code></pre>
<ol start="2">
<li>Create a <code>DynamicParameters</code> object and add parameter to it. For an output parameter, you must specify <code>ParameterDirection.Output</code></li>
<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 your parameters</li>
<li>Retrieve the parameter value from the parameters passed to the stored procedure:</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;@OutputParam2&quot;, dbType: DbType.Int32, direction: ParameterDirection.Output);
	
	// Execute the stored procedure
	var result = connection.Execute(
		&quot;MyStoredProcedure&quot;,
		parameters,
		commandType: CommandType.StoredProcedure
	);
	
	// Get the output parameter value
	var outputParam2Value = parameters.Get&lt;int&gt;(&quot;@OutputParam2&quot;);
	
	// Do something with the output parameter value..
	Console.WriteLine($&quot;Output parameter value: {outputParam2Value}&quot;);
}
</code></pre>

Advertising Break! 5 seconds left

Did you know...