Setting SYSTEM_VERSIONING to ON failed.

[PatPat1567]

Error Message: Setting SYSTEM_VERSIONING to ON failed because table '{name}' has a FOREIGN KEY with cascading DELETE or UPDATE.

The error occurs when I add a DbSet to the DbContext file and try to implement the migration. The table that is failing is not necessarily the same each time I run the update-database command in the Package Manager Console.

[bcallaghan-et]

This is a limitation of SQL Server. Older versions did not support temporal tables that were on the dependent side of a cascading relationship. Newer versions have fixed this, based on the documentation. If you are stuck on an older version, you can try changing the delete behavior with the following:

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Post>()
        .HasOne(p => p.Blog)
        .WithMany(b => b.Posts)
        .OnDelete(DeleteBehavior.Restrict); // Select the behavior that best fits your model.
}