FREE AI Dapper Chat: Ask Online Any Entity Framework Questions

<p>You don't need to add <code>EXEC</code> to the command text when specifing the command type to <code>CommandType.StoredProcedure</code>. However, you need add <code>EXEC</code> 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 result = connection.Query(&quot;MyStoredProcedure&quot;, commandType: CommandType.StoredProcedure).ToList();
}
</code></pre>
<ol start="2">
<li>With <code>CommandType.Text</code>, you must use EXEC:</li>
</ol>
<pre><code class="language-csharp">using (var connection = new SqlConnection(&quot;connectionString&quot;))
{
    var result = connection.Query(&quot;EXEC MyStoredProcedure&quot;, commandType: CommandType.Text).ToList();
}
</code></pre>
<ol start="3">
<li>With no command type specified, you must use EXEC:</li>
</ol>
<pre><code>using (var connection = new SqlConnection(&quot;connectionString&quot;))
{
    var result = connection.Query(&quot;EXEC MyStoredProcedure&quot;).ToList();
}
</code></pre>

Advertising Break! 5 seconds left

Did you know...