title: CommandType.Text vs CommandType.StoredProcedure
body: <p>Is there any benefit to explicitly using the StoredProcedure CommandType as opposed to just using a Text Command?  In other words, is</p>
  
  <pre><code>cmd = new SqlCommand("EXEC StoredProc(@p1, @p2)");
  cmd.CommandType = CommandType.Text;
  cmd.Parameters.Add("@p1", 1);
  cmd.Parameters.Add("@p2", 2);
  </code></pre>
  
  <p>any worse than</p>
  
  <pre><code>cmd = new SqlCommand("StoredProc");
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.Parameters.Add("@p1", 1);
  cmd.Parameters.Add("@p2", 2);
  </code></pre>
  
  <p>EDIT: Fixed bad copy paste job (again).  Also, the whole point of the question is for a data access class.  I'd much rather be able to pass the stored proc name and parameters in one line as opposed to extra lines for each parameter.</p>