Untitled

using System;
using System.Configuration;
using System.Data.Common;

public static class Migrate
{
    public static void Start()
    {

        try
        {
            EnsureInit();
            ExecuteMigration("StoreCategory_SearchOptimization",
@"ALTER TABLE  dbo.[Category]
ADD SearchOptimisationPageTitle nvarchar(max) NULL,
SearchOptimisationPageKeywords nvarchar(max) NULL,
SearchOptimisationPageDescription nvarchar(max) NULL");
        }
        catch (Exception ex)
        {
            Trace.TraceLogFactory.Create().Error("Error during app migration. " + ex.Message, ex);
        }
    }

    private static void ExecuteMigration(string migrationId, string migration)
    {
        ExecuteScript(@"IF NOT EXISTS (SELECT * FROM [dbo].[__Migrations] WHERE MigrationID = '" + migrationId + @"')
BEGIN

" + migration + @"

INSERT INTO [dbo].[__Migrations] ([MigrationId] ,[LastExecuted]) VALUES ('" + migrationId + @"', GETDATE())
END
");
    }


    private static void EnsureInit()
    {
        ExecuteScript(@"IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[__Migrations]') AND type in (N'U'))
CREATE TABLE [dbo].[__Migrations](
        [MigrationID] [nvarchar](450) NOT NULL PRIMARY KEY,
        [LastExecuted] [datetime2](7) NOT NULL )");
    }

    private static void ExecuteScript(string sql)
    {
        using(var con = CreateOpenConnection())
        {
            var cmd = con.CreateCommand();
            cmd.CommandText = sql;
            cmd.ExecuteNonQuery();

        }
    }

    private static DbConnection CreateOpenConnection()
    {
        var connectionConfig = ConfigurationManager.ConnectionStrings["JA.Catalogue.Properties.Settings.CatalogueConnectionString"];

        var factory = DbProviderFactories.GetFactory("System.Data.SqlClient");

        var con = factory.CreateConnection();
        con.ConnectionString = connectionConfig.ConnectionString;
        con.Open();

        return con;
    }
}