title: How to fix "SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value."
body: <blockquote>
    <p>SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.</p>
  </blockquote>
  
  <p>my code is like this:</p>
  
  <pre><code>        using (var contxt = new realtydbEntities())
          {
              var status = GetStatus();
  
              var repIssue = new RepairIssue()
              {
                  CreaterId = AuthorId,
                  RepairItemDesc = this.txtDescription.Text,
                  CreateDate = DateTime.Now,//here's the problem
                  RepairIssueStatu = status
              };
  
              contxt.AddObject("RepairIssues", repIssue);
              contxt.SaveChanges();
          }
  </code></pre>
  
  <p>the <strong>CreateDate</strong> property mapping to a column which type is <strong>smalldatetime</strong>.</p>
  
  <p>how to make this code run?</p>