EF CORE 2.1 HasConversion on all properties of type datetime

Question

I previously used DateTimeKindEntityMaterializerSource (Git) to convert all DateTime to UTC when reading entities because the default was unspecified.

With EF core 2.1 the DateTimeKindEntityMaterializerSource no longer works but we can actually do this

         builder         .Entity<ESDataQuotation>()         .Property(e => e.CreatedDate)         .HasConversion(v => v, v => DateTime.SpecifyKind(v, DateTimeKind.Utc)); 

However, I have many properties of DateTime and I would like if there is a way to make the conversion for all property of type DateTime.

Answer 1

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);     } }