title: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value
body: <p>I have an ASP.NET MVC application where I am editing an existing database to update a paticular field, <code>DateTime</code>. My database has 4 fields, two of which are <strong>DateCreated</strong> and <strong>DateModified</strong>. When I try to update the field, I want to keep <strong>DateCreated</strong> time the same, no reason to update the date it was created, and I change the DateModified time to the current time using <code>DateTime.Now</code> </p>
  
  <p>Here is the given code just in-case I am doing something wrong. This is my first time using ASP.NET MVC so go gentle. I have seen other answers where <code>Context</code> is called, but I can't find any reference to it. When I run the application I receive the error message in the title and the <code>contractEntity.SaveChanges()</code> is in red.</p>
  
  <pre><code>public ActionResult Edit(Contract editContract) {
  var contract = (from c in contractEntity.Contracts where c.Id == editContract.Id select c).First();
  if (!ModelState.IsValid)
      return View(contract);
  // editContract.DateCreated = contract.DateCreated;
  // editContract.DateModified = DateTime.Now;
    contractEntity.ApplyCurrentValues(contract.EntityKey.EntitySetName, editContract);
    contractEntity.SaveChanges();
    return RedirectToAction("Index");
  }
  </code></pre>
  
  <p>Please, any help is appreciated. Thanks.</p>