On Delete Cascade is applied to all tables automatically

[bastienJS]

When I do this in EF 7 RC1

   builder.Entity<Schoolclass>()
                        .HasMany(x => x.Pupils)
                        .WithOne(x => x.Schoolclass)
                        .OnDelete(Microsoft.Data.Entity.Metadata.DeleteBehavior.Cascade);

I just change On Delete Cascade for ONE table.

When I look at the migration code, all tables Referential Integrity is changed ???

from ReferentialAction.Restrict to Cascade !!!

using System;
using System.Collections.Generic;
using Microsoft.Data.Entity.Migrations;

namespace TGB.DataProvider.Migrations
{
    public partial class DeleteONCascadeforPupil : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropForeignKey(name: "FK_Pupil_Schoolclass_SchoolclassId", table: "Pupil");
            migrationBuilder.DropForeignKey(name: "FK_Schoolclass_Schoolyear_SchoolyearId", table: "Schoolclass");
            migrationBuilder.DropForeignKey(name: "FK_SchoolclassTest_Schoolclass_SchoolclassId", table: "SchoolclassTest");
            migrationBuilder.DropForeignKey(name: "FK_SchoolclassTest_Test_TestId", table: "SchoolclassTest");
            migrationBuilder.DropForeignKey(name: "FK_SubjectPupil_Pupil_PupilId", table: "SubjectPupil");
            migrationBuilder.DropForeignKey(name: "FK_SubjectPupil_Subject_SubjectId", table: "SubjectPupil");
            migrationBuilder.DropForeignKey(name: "FK_SubjectTest_Subject_SubjectId", table: "SubjectTest");
            migrationBuilder.DropForeignKey(name: "FK_SubjectTest_Test_TestId", table: "SubjectTest");
            migrationBuilder.DropForeignKey(name: "FK_TestType_Schoolyear_SchoolyearId", table: "TestType");
            migrationBuilder.DropForeignKey(name: "FK_TestTypeTest_Test_TestId", table: "TestTypeTest");
            migrationBuilder.DropForeignKey(name: "FK_TestTypeTest_TestType_TestTypeId", table: "TestTypeTest");
            migrationBuilder.AddForeignKey(
                name: "FK_Pupil_Schoolclass_SchoolclassId",
                table: "Pupil",
                column: "SchoolclassId",
                principalTable: "Schoolclass",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
            migrationBuilder.AddForeignKey(
                name: "FK_Schoolclass_Schoolyear_SchoolyearId",
                table: "Schoolclass",
                column: "SchoolyearId",
                principalTable: "Schoolyear",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
            migrationBuilder.AddForeignKey(
                name: "FK_SchoolclassTest_Schoolclass_SchoolclassId",
                table: "SchoolclassTest",
                column: "SchoolclassId",
                principalTable: "Schoolclass",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
            migrationBuilder.AddForeignKey(
                name: "FK_SchoolclassTest_Test_TestId",
                table: "SchoolclassTest",
                column: "TestId",
                principalTable: "Test",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
            migrationBuilder.AddForeignKey(
                name: "FK_SubjectPupil_Pupil_PupilId",
                table: "SubjectPupil",
                column: "PupilId",
                principalTable: "Pupil",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
            migrationBuilder.AddForeignKey(
                name: "FK_SubjectPupil_Subject_SubjectId",
                table: "SubjectPupil",
                column: "SubjectId",
                principalTable: "Subject",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
            migrationBuilder.AddForeignKey(
                name: "FK_SubjectTest_Subject_SubjectId",
                table: "SubjectTest",
                column: "SubjectId",
                principalTable: "Subject",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
            migrationBuilder.AddForeignKey(
                name: "FK_SubjectTest_Test_TestId",
                table: "SubjectTest",
                column: "TestId",
                principalTable: "Test",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
            migrationBuilder.AddForeignKey(
                name: "FK_TestType_Schoolyear_SchoolyearId",
                table: "TestType",
                column: "SchoolyearId",
                principalTable: "Schoolyear",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
            migrationBuilder.AddForeignKey(
                name: "FK_TestTypeTest_Test_TestId",
                table: "TestTypeTest",
                column: "TestId",
                principalTable: "Test",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
            migrationBuilder.AddForeignKey(
                name: "FK_TestTypeTest_TestType_TestTypeId",
                table: "TestTypeTest",
                column: "TestTypeId",
                principalTable: "TestType",
                principalColumn: "Id",
                onDelete: ReferentialAction.Cascade);
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropForeignKey(name: "FK_Pupil_Schoolclass_SchoolclassId", table: "Pupil");
            migrationBuilder.DropForeignKey(name: "FK_Schoolclass_Schoolyear_SchoolyearId", table: "Schoolclass");
            migrationBuilder.DropForeignKey(name: "FK_SchoolclassTest_Schoolclass_SchoolclassId", table: "SchoolclassTest");
            migrationBuilder.DropForeignKey(name: "FK_SchoolclassTest_Test_TestId", table: "SchoolclassTest");
            migrationBuilder.DropForeignKey(name: "FK_SubjectPupil_Pupil_PupilId", table: "SubjectPupil");
            migrationBuilder.DropForeignKey(name: "FK_SubjectPupil_Subject_SubjectId", table: "SubjectPupil");
            migrationBuilder.DropForeignKey(name: "FK_SubjectTest_Subject_SubjectId", table: "SubjectTest");
            migrationBuilder.DropForeignKey(name: "FK_SubjectTest_Test_TestId", table: "SubjectTest");
            migrationBuilder.DropForeignKey(name: "FK_TestType_Schoolyear_SchoolyearId", table: "TestType");
            migrationBuilder.DropForeignKey(name: "FK_TestTypeTest_Test_TestId", table: "TestTypeTest");
            migrationBuilder.DropForeignKey(name: "FK_TestTypeTest_TestType_TestTypeId", table: "TestTypeTest");
            migrationBuilder.AddForeignKey(
                name: "FK_Pupil_Schoolclass_SchoolclassId",
                table: "Pupil",
                column: "SchoolclassId",
                principalTable: "Schoolclass",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
            migrationBuilder.AddForeignKey(
                name: "FK_Schoolclass_Schoolyear_SchoolyearId",
                table: "Schoolclass",
                column: "SchoolyearId",
                principalTable: "Schoolyear",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
            migrationBuilder.AddForeignKey(
                name: "FK_SchoolclassTest_Schoolclass_SchoolclassId",
                table: "SchoolclassTest",
                column: "SchoolclassId",
                principalTable: "Schoolclass",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
            migrationBuilder.AddForeignKey(
                name: "FK_SchoolclassTest_Test_TestId",
                table: "SchoolclassTest",
                column: "TestId",
                principalTable: "Test",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
            migrationBuilder.AddForeignKey(
                name: "FK_SubjectPupil_Pupil_PupilId",
                table: "SubjectPupil",
                column: "PupilId",
                principalTable: "Pupil",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
            migrationBuilder.AddForeignKey(
                name: "FK_SubjectPupil_Subject_SubjectId",
                table: "SubjectPupil",
                column: "SubjectId",
                principalTable: "Subject",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
            migrationBuilder.AddForeignKey(
                name: "FK_SubjectTest_Subject_SubjectId",
                table: "SubjectTest",
                column: "SubjectId",
                principalTable: "Subject",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
            migrationBuilder.AddForeignKey(
                name: "FK_SubjectTest_Test_TestId",
                table: "SubjectTest",
                column: "TestId",
                principalTable: "Test",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
            migrationBuilder.AddForeignKey(
                name: "FK_TestType_Schoolyear_SchoolyearId",
                table: "TestType",
                column: "SchoolyearId",
                principalTable: "Schoolyear",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
            migrationBuilder.AddForeignKey(
                name: "FK_TestTypeTest_Test_TestId",
                table: "TestTypeTest",
                column: "TestId",
                principalTable: "Test",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
            migrationBuilder.AddForeignKey(
                name: "FK_TestTypeTest_TestType_TestTypeId",
                table: "TestTypeTest",
                column: "TestTypeId",
                principalTable: "TestType",
                principalColumn: "Id",
                onDelete: ReferentialAction.Restrict);
        }
    }
}

[rowanmiller]

Starting in RC1 - cascade delete is on by default for all required relationships (this is the same behavior as EF6 and we were just waiting for cascade delete to be implemented to enable it). After aligning the schema with the new convention, you may still hit issue #3751 where migrations will continually try to drop and re-create foreign keys because it thinks the cascade behavior has changed. This is fixed in our current code base (and will ship in RC2).

[bastienJS]

Thanks cant wait for RC2!