using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace EfCoreTemporalTablePart3.Migrations { public partial class SuppressiontemporalitéEmploye : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropColumn( name: "PeriodEnd", table: "Employe") .Annotation("SqlServer:IsTemporal", true) .Annotation("SqlServer:TemporalHistoryTableName", "EmployeHistory") .Annotation("SqlServer:TemporalHistoryTableSchema", null) .Annotation("SqlServer:TemporalPeriodEndColumnName", "PeriodEnd") .Annotation("SqlServer:TemporalPeriodStartColumnName", "PeriodStart"); migrationBuilder.DropColumn( name: "PeriodStart", table: "Employe") .Annotation("SqlServer:IsTemporal", true) .Annotation("SqlServer:TemporalHistoryTableName", "EmployeHistory") .Annotation("SqlServer:TemporalHistoryTableSchema", null) .Annotation("SqlServer:TemporalPeriodEndColumnName", "PeriodEnd") .Annotation("SqlServer:TemporalPeriodStartColumnName", "PeriodStart"); migrationBuilder.AlterTable( name: "Employe") .OldAnnotation("SqlServer:IsTemporal", true) .OldAnnotation("SqlServer:TemporalHistoryTableName", "EmployeHistory") .OldAnnotation("SqlServer:TemporalHistoryTableSchema", null) .OldAnnotation("SqlServer:TemporalPeriodEndColumnName", "PeriodEnd") .OldAnnotation("SqlServer:TemporalPeriodStartColumnName", "PeriodStart"); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.AlterTable( name: "Employe") .Annotation("SqlServer:IsTemporal", true) .Annotation("SqlServer:TemporalHistoryTableName", "EmployeHistory") .Annotation("SqlServer:TemporalHistoryTableSchema", null) .Annotation("SqlServer:TemporalPeriodEndColumnName", "PeriodEnd") .Annotation("SqlServer:TemporalPeriodStartColumnName", "PeriodStart"); migrationBuilder.AddColumn( name: "PeriodEnd", table: "Employe", type: "datetime2", nullable: false, defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified)) .Annotation("SqlServer:IsTemporal", true) .Annotation("SqlServer:TemporalPeriodEndColumnName", "PeriodEnd") .Annotation("SqlServer:TemporalPeriodStartColumnName", "PeriodStart"); migrationBuilder.AddColumn( name: "PeriodStart", table: "Employe", type: "datetime2", nullable: false, defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified)) .Annotation("SqlServer:IsTemporal", true) .Annotation("SqlServer:TemporalPeriodEndColumnName", "PeriodEnd") .Annotation("SqlServer:TemporalPeriodStartColumnName", "PeriodStart"); } } }