Using DateTime properties in Code-First Entity Framework and SQL Server

by

You can specify the type in Fluent API:

modelBuilder.Entity<Book>()
    .Property(f => f.DateTimeAdded)
    .HasColumnType("datetime2");

This creates a datetime2(7) column in the database. If you want to finetune the precision you can use:

modelBuilder.Entity<Book>()
    .Property(f => f.DateTimeAdded)
    .HasColumnType("datetime2")
    .HasPrecision(0);

… for a datetime2(0) column in the DB.

However, the code you have shown in your question works because the datetime type allows to store dates back to around 1750. The exception occurs only for earlier dates. A common reason for this exception is an uninitialized DateTime property because it represents the year 0001 which can’t be stored in a datetime column in SQL Server.

There is no corresponding attribute to define this with data annotations. It’s only possible with Fluent API.

More Related Contents:

  1. Daylight saving time and time zone best practices [closed]
  2. Determine Whether Two Date Ranges Overlap
  3. Format current date and time in VBScript
  4. How do I convert a date/time string to a DateTime object in Dart?
  5. Kotlin DateTimeParseException
  6. Best way to store date/time in mongodb
  7. How to get the current time as datetime
  8. What’s the difference between ISO 8601 and RFC 3339 Date Formats?
  9. How do you specify the date format used when JAXB marshals xsd:dateTime?
  10. Convert 12-hour date/time to 24-hour date/time
  11. Why are date/time values interpreted incorrectly when patching/saving?
  12. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  13. Parsing of Ordered Timestamps in Local Time (to UTC) While Observing Daylight Saving Time
  14. Pythonic way to combine datetime.date and datetime.time objects
  15. How to format a DateTime in PowerShell
  16. Entity Framework Code First Lazy Loading
  17. Aggregate Daily Data to Month/Year intervals
  18. Calculate the number of weekdays between 2 dates in R
  19. IE JavaScript date parsing error
  20. Exclude a field/property from the database with Entity Framework 4 & Code-First
  21. How to set default value for POCO’s in EF CF?
  22. Entity Framework creates a plural table name, but the view expects a singular table name?
  23. Best practices with saving datetime & timezone info in database when data is dependant on datetime
  24. How do I convert an interval into a number of hours with postgres?
  25. Possible to default DateTime field to GETDATE() with Entity Framework Migrations?
  26. Aggregating hourly data into daily aggregates
  27. How to convert DbSet in Entity framework to ObjectQuery
  28. Entity Framework Code First naming conventions – back to plural table names?
  29. Twig date difference
  30. How to get timezone, Language and County Id in flutter by the location of device in flutter?

Leave a Comment