title: SqlCommand Parameters Add vs. AddWithValue
body: <p>When should I use <code>Parameters. Add/AddWithValue</code>?
  In the following MSDN example they use <code>Parameters.Add</code> for <code>int</code> and <code>Parameters.AddWithValue</code> for <code>string</code></p>
  
  <pre><code>command.Parameters.Add("@ID", SqlDbType.Int);
  command.Parameters["@ID"].Value = customerID;
  
  command.Parameters.AddWithValue("@demographics", demoXml);
  </code></pre>
  
  <p>What is the best to use for <code>datetime</code></p>