title: Should I use the Date or DateTime SqlDbType when adding a DateTime C# value for a Date SQL Server field?
body: <p>I've got a table with a field of Date data type. Although I would expect just the raw date in that field when inserting a value into it like so:</p>
  
  <pre><code>update reportsgenerated
  set begindate = '2016-02-01'
  where rptgenid = 2;
  </code></pre>
  
  <p>...it actually sems to store a date time value, as it is represented in LINQPad as "<em>2/1/2016 12:00:00 AM</em>".</p>
  
  <p>The C# value I'm assigning to the parameter when inserting is a DateTime type (as C# doesn't have a "Date"-only type):</p>
  
  <pre><code>DateTime begDate = // bla
  </code></pre>
  
  <p>That being the case, should I designate the parameter as a Date type, to match the table:</p>
  
  <pre><code>insertRptsGenerated.Parameters.Add("@BeginDate", SqlDbType.Date).Value = begDate;
  </code></pre>
  
  <p>...or as a DateTime type, to match the assigned value's type:</p>
  
  <pre><code>insertRptsGenerated.Parameters.Add("@BeginDate", SqlDbType.DateTime).Value = begDate;
  </code></pre>
  
  <p>?</p>