EF CORE 2.1 HasConversion on all properties of type datetime

by

Excerpt from EF Core 2.1 Value Conversions documentation topic:

There is currently no way to specify in one place that every property of a given type must use the same value converter. This feature will be considered for a future release.

Until then, you can use the typical loop at the end of the OnModelCreating override where all entity types and properties are discovered:

var dateTimeConverter = new ValueConverter<DateTime, DateTime>(
    v => v, v => DateTime.SpecifyKind(v, DateTimeKind.Utc));

foreach (var entityType in modelBuilder.Model.GetEntityTypes())
{
    foreach (var property in entityType.GetProperties())
    {
        if (property.ClrType == typeof(DateTime) || property.ClrType == typeof(DateTime?))
            property.SetValueConverter(dateTimeConverter);
    }
}

More Related Contents:

  1. Dynamically change connection string in Asp.Net Core
  2. Dynamically access table in EF Core 2.0
  3. How to mock an async repository with Entity Framework Core
  4. .Net Core 3.0 possible object cycle was detected which is not supported
  5. .NET Core 2.1 Identity get all users with their associated roles
  6. Cannot access a disposed object in ASP.NET Core when injecting DbContext
  7. How to instantiate a DbContext in EF Core
  8. Command dotnet ef not found
  9. Unable to create migrations after upgrading to ASP.NET Core 2.0
  10. Dynamically changing schema in Entity Framework Core
  11. How to unapply a migration in ASP.NET Core with EF Core
  12. Is there an Entity Framework 7 Database-First POCO Generator?
  13. How to make EF-Core use a Guid instead of String for its ID/Primary key
  14. loading a full hierarchy from a self referencing table with EntityFramework.Core
  15. In-memory database doesn’t save data
  16. Avoid or control circular references in Entity Framework Core
  17. Configuring Dbcontext as Transient
  18. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  19. Add migration with different assembly
  20. ASP – Core Migrate EF Core SQL DB on Startup
  21. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  22. How to load navigation properties on an IdentityUser with UserManager
  23. How to get user information in DbContext using Net Core
  24. How should I manage DbContext Lifetime in MVC Core?
  25. Implementing recursive property loading in EF Core
  26. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  27. Update-Database command is not working in ASP.Net Core / Entity Framework Core because object in database already exists
  28. Render Razor View to string in ASP.NET Core
  29. The entity type ‘Microsoft.AspNet.Identity.EntityFramework.IdentityUserLogin’ requires a key to be defined
  30. ASP.Net Core MVC – Client-side validation for custom attribute

Leave a Comment