title: Conversion of a datetime2 data type to a datetime data type results out-of-range value
body: <p>I've got a datatable with 5 columns, where a row is being filled with data then saved to the database via a transaction.</p>
  
  <p>While saving, an error is returned:</p>
  
  <blockquote>
    <p>The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value</p>
  </blockquote>
  
  <p>It implies, as read, that my datatable has a type of <code>DateTime2</code> and my database a <code>DateTime</code>; that is wrong.</p>
  
  <p>The date column is set to a <code>DateTime</code> like this: </p>
  
  <p><code>new DataColumn("myDate", Type.GetType("System.DateTime"))</code></p>
  
  <p><strong>Question</strong></p>
  
  <p>Can this be solved in code or does something have to be changed on a database level?</p>