title: Array of Sized/Typed SqlParameters
body: <p>I'm trying to create an array of dbTyped and sized SqlParameters.  This works fine but results in changing code both places if I need another column.</p>
  
  <pre><code>SqlParameter[] parameters = {
                                    new SqlParameter("@first_name", SqlDbType.VarChar, 50),
                                    new SqlParameter("@last_name", SqlDbType.VarChar, 50),
                                    new SqlParameter("@middle_name", SqlDbType.VarChar, 50),
                                    new SqlParameter("@empid", SqlDbType.Int)
                              };
  parameters[0].Value = to.FirstName;
  parameters[1].Value = to.LastName;
  parameters[2].Value = to.MiddleName;
  parameters[3].Value = to.EmpId;
  </code></pre>
  
  <p>What is a better way of doing this?</p>