在 EF Core 中设置默认日期时间值

所以问题是我无法设置模型以便迁移显示DateTimeKind.Utc代替DateTimeKind.Unspecified我正在这样做：

contactsConfiguration
   .Property(c => c.DateAdded)
   .ValueGeneratedOnAdd()
   .HasConversion(v => v, v => DateTime.SpecifyKind(v, DateTimeKind.Utc))

有任何想法吗？

这似乎对我有用：

public partial class MyDbContext : DbContext
{ 
   ... 

    /// <summary>
    /// Deserializes DateTime so if its Kind is Unspecified then it's set to Utc. 
    /// Does nothing on Serialization as SQL Server discards this info when saving to DateTime fields. 
    /// </summary>
    public class DateTimeToUtcConverter : ValueConverter<DateTime, DateTime>
    {
        public DateTimeToUtcConverter() : base(Serialize, Deserialize, null)
        {
        }

        static Expression<Func<DateTime, DateTime>> Deserialize = 
                x => x.Kind == DateTimeKind.Unspecified ? DateTime.SpecifyKind(x, DateTimeKind.Utc) : x;
        static Expression<Func<DateTime, DateTime>> Serialize = x => x;
    }

    protected override void ConfigureConventions(ModelConfigurationBuilder configurationBuilder)
    {
        // Configure ALL the DateTime properties in our EF model so they'll have DateTime.Kind set to Utc. 
        // (We'll also have to do this manually for any SQL queries we don't use EFCore to map to objects)
        configurationBuilder
            .Properties<DateTime>()
            .HaveConversion<DateTimeToUtcConverter>();
    }
}

我添加了评论here https://github.com/dotnet/efcore/issues/12994#issuecomment-1328107538，也许聪明的人会回复更好的解决方案。