Found a solution, searched the migrations themselves and changed from Cascading to Restrict

migration.AddForeignKey(
name: "FK_Films_People_ComposerId",
column: "ComposerId",
proncipalTable: "People",
principalColumn: "Id",
onDelete: ReferentialAction.Restrict);