The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value

by

The issue is that you’re using ApplyPropertyChanges with a model object that has only been populated with data in the form (headline, story, and image). ApplyPropertyChanges applies changes to all properties of the object, including your uninitialized DateTime, which is set to 0001-01-01, which is outside of the range of SQL Server’s DATETIME.

Rather than using ApplyPropertyChanges, I’d suggest retrieving the object being modified, change the specific fields your form edits, then saving the object with those modifications; that way, only changed fields are modified. Alternately, you can place hidden inputs in your page with the other fields populated, but that wouldn’t be very friendly with concurrent edits.

Update:

Here’s an untested sample of just updating some fields of your object (this is assuming you’re using LINQ to SQL):

var story = _db.ArticleSet.First(a => a.storyId == ArticleToEdit.storyId);
story.headline = ArticleToEdit.headline;
story.story = ArticleToEdit.story;
story.image = ArticleToEdit.image;
story.modifiedDate = DateTime.Now;
_db.SubmitChanges();

More Related Contents:

  1. What is ViewModel in MVC?
  2. Two related questions on jqGrid column header filters and the advanced filtering dialog
  3. How do you request static .html files under the ~/Views folder in ASP.NET MVC?
  4. Adding another “Pet” to a Model Form
  5. How to lock down paths in ASP.NET MVC?
  6. Why should I use view models?
  7. ASP.NET MVC Routing Via Method Attributes [closed]
  8. In MVC, how do I return a string result?
  9. ASP.NET MVC 4 Web API Authentication with Membership Provider
  10. ASP.NET MVC Html.ValidationSummary(true) does not display model errors
  11. Web API and ValidateAntiForgeryToken
  12. HTML.ActionLink vs Url.Action in ASP.NET Razor
  13. ASP.NET MVC and Ajax, concurrent requests?
  14. ASP.NET MVC framework 4.5 CSS bundle does not work on the hosting
  15. Is there a good/proper way of solving the dependency injection loop problem in the ASP.NET MVC ContactsManager tutorial?
  16. Error: «Could not load type MvcApplication»
  17. What is the advantage of using async with MVC5?
  18. 404 Http error handler in Asp.Net MVC (RC 5)
  19. Role-based access control (RBAC) vs. Claims-based access control (CBAC) in ASP.NET MVC
  20. Adding a controller factory to ASP MVC
  21. asp.net mvc keep object alive, information
  22. maxlength attribute of a text box from the DataAnnotations StringLength in Asp.Net MVC
  23. How to compile cshtml before runtime
  24. CORS in ASP .NET MVC5
  25. how to implement ASP.NET Identity to an empty MVC project
  26. ASP.net MVC – Display Template for a collection
  27. How to reuse Areas, Controllers, Views, Models, Routes in multiple apps or websites
  28. How to create a function in a cshtml template?
  29. Unable to get windows authentication to work through local IIS
  30. View Model IEnumerable property is coming back null (not binding) from post method?

Leave a Comment