FREE AI Dapper Chat: Ask Online Any Entity Framework Questions

<p>You don't need to add parameter names to the command text when specifing the command type to <code>CommandType.StoredProcedure</code>. However, you need add <code>EXEC</code> and parameter names if you don't specify a  command type or you set the command type to <code>CommandType.Text</code>.</p>
<ol>
<li>With <code>CommandType.StoredProcedure</code>, you don't have to use EXEC:</li>
</ol>
<pre><code class="language-csharp">using (var connection = new SqlConnection(&quot;connectionString&quot;))
{
    var parameters = new DynamicParameters();
    parameters.Add(&quot;@Parameter1&quot;, value1);
    parameters.Add(&quot;@Parameter2&quot;, value2);
	
    var result = connection.Query(&quot;MyStoredProcedure&quot;, parameters, commandType: CommandType.StoredProcedure).ToList();
}
</code></pre>
<ol start="2">
<li>With <code>CommandType.Text</code>, you must use EXEC and specify parameter names:</li>
</ol>
<pre><code class="language-csharp">using (var connection = new SqlConnection(&quot;connectionString&quot;))
{
    var parameters = new DynamicParameters();
    parameters.Add(&quot;@Parameter1&quot;, value1);
    parameters.Add(&quot;@Parameter2&quot;, value2);

var result = connection.Query(&quot;EXEC MyStoredProcedure @Parameter1, @Parameter2&quot;, parameters, commandType: CommandType.Text).ToList();
}
</code></pre>

Advertising Break! 5 seconds left

Did you know...