AllReady.Migrations.AddTimeZoneIDToEvent.Up C# (CSharp) Метод

        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AddColumn<string>(
                name: "TimeZoneId",
                table: "Event",
                nullable: false,
                defaultValue: "Central Standard Time");

            //Set the TimeZoneID for existing events based on the TimeZoneID of the parent campaign
            migrationBuilder.Sql(
@"UPDATE e SET e.[TimeZoneID] = c.[TimeZoneID]
  FROM [Event] e
       INNER JOIN Campaign c ON c.Id = e.CampaignId
");
        }