title: SqlDateTime overflow when inserting value with DateTime.Now
body: <p>Lately I have quite odd error while trying to do <code>db.SubmitChanges()</code>:</p>
  
  <blockquote>
    <p>SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.</p>
  </blockquote>
  
  <p>The point is, I only use <code>DateTime.Now</code> to set property in my object, and after calling <code>Response.Write(DateTime.Now.ToString());</code> it shows <code>17-04-2013 18:03:13</code> as it should be.</p>
  
  <p>It was not happening earlier, and now the function always breaks. I'm completely clueless - date on my SQL server seems to be ok.</p>
  
  <p>What may cause it?</p>
  
  <p><strong>Edit</strong></p>
  
  <p>I don't think it would help (it just too simple to have any errors IMO), but there's my function:</p>
  
  <pre><code>public bool ReportLogIn(int UserID, string IP, int Succeed ... ) {
      A_UserLoginHistory Report = new A_UserLoginHistory();
  
      Report.IP = IP;
      Report.UserID = UserID;
      Report.Status = Succeed;
      Report.Date = DateTime.Now; //the only DateTime field
      ...
  
      try {
          db.A_UserLoginRegistry.InsertOnSubmit(Report);
          db.SubmitChanges();
          return true;
      } catch (Exception e) {
          ErrorLog.AddError(e.ToString());
          return false;
      }
  }
  </code></pre>