DateTime.Kind comes back as Unspecified

A slight variation of this is that it would be nice if one could configure the default DateTimeKind. For example, I know that all dates in my database are Utc, so it would be nice if this was specified for all fetched dates in the DbContext, or maybe configurable per entity property?

Please note that EntityMaterializerSource is internal code and any solution like that shown above may get broken with a new release of EF. That doesn’t mean I’m saying not to use it–it’s publicly available internal code for a reason–but please be aware of the risk associated with it.

Starting in EF Core 2.1, this would be one way to deal with DateTime.Kind:

modelBuilder
    .Entity<Foo>()
    .Property(e => e.SomeDate)
    .HasConversion(v => v, v => DateTime.SpecifyKind(v, DateTimeKind.Local));

This will ensure every time the date is read from the database it is specified as Local automatically.