title: Why can't SQL server see the parameter I've added?
body: <p>I'm trying to call a parameterized stored procedure from a console app. Here is the code:</p>
  
  <pre><code>var connection = new SqlConnection(connectionString);
  var cmd = new SqlCommand("MyStoredProcedure", connection);
  
  connection.Open();
  
  cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = email;
  cmd.Parameters.Add("@Account", SqlDbType.VarChar).Value = accountNumber;
  cmd.Parameters.Add("@EmployeeId", SqlDbType.VarChar).Value = $"Prod-{empIdNumber}";
  
  cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>I get an exception returned that the stored procedure expects an <code>@EmployeeId</code> parameter which was not provided. I have double checked the spelling.</p>
  
  <p>Can anyone tell me what I'm missing?</p>
  
  <p>edit: I should add, that the stored procedure works fine when called directly.</p>