Running a set of statements in an Entity Framework migration (this particular example is in relation to https://github.com/davidfowl/JabbR/issues/751)

gistfile1.txt

    using System.Data.Entity.Migrations;
    using System;
    
    public partial class ChangeIndexingOnChatMessages : DbMigration
    {
        private static readonly string[] Statements = new[] {
            "alter table dbo.ChatMessages drop constraint PK_ChatMessages",
            "create clustered index CX_ChatMessages_When on dbo.ChatMessages ([When])",
            "alter table dbo.ChatMessages add constraint PK_ChatMessages primary key nonclustered ([Key])"
        };

        public override void Up()
        {
            foreach (var statement in Statements)
                Sql(statement);
        }

        public override void Down()
        {
            // Create a similar set of statements to reverse the index changes
        }
    }