201206250141447_ExecuteELMAHSql.cs

using System;
using System.Data.Entity.Migrations;
using System.IO;

namespace NuGetGallery.Migrations
{
    public partial class ExecuteELMAHSql : DbMigration
    {
        private static readonly string[] Go = new[] { "GO" };

        public override void Up()
        {
            using (var stream = typeof(ExecuteELMAHSql).Assembly.GetManifestResourceStream("NuGetGallery.Infrastructure.Elmah.SqlServer.sql"))
            {
                using (var streamReader = new StreamReader(stream))
                {
                    var statements = streamReader.ReadToEnd().Split(Go, StringSplitOptions.RemoveEmptyEntries);

                    foreach (var statement in statements)
                    {
                        if (String.IsNullOrWhiteSpace(statement))
                        {
                            continue;
                        }

                        Sql(statement);
                    }
                }
            }
        }

        public override void Down()
        {
        }
    }
}