Entity Framework Core and SQL Server 2016 temporal tables

I tried below options and they are working.

  1. option 1: removed appstart, append fields from entities and dbcontext mappings and updates/insert started working properly.

  2. option 2: decorate period columns with attributes as below.


[DatabaseGenerated(DatabaseGeneratedOption.Computed)]
public DateTime StartTime { get; set; }

[DatabaseGenerated(DatabaseGeneratedOption.Computed)]
public DateTime EndTime { get; set; } 

There currently is no better solution for this, and the feature is on the backlog.