public static void Setup(DbConnection connection, string schemaName)
{
const string sql =
"IF (NOT EXISTS ( " +
"SELECT 1 " +
"FROM INFORMATION_SCHEMA.TABLES " +
"WHERE TABLE_SCHEMA = '{0}' " +
"AND TABLE_NAME = '__DeploymentHistory')) " +
"BEGIN " +
"CREATE TABLE [{0}].[__DeploymentHistory]( " +
"[DeploymentId][NVARCHAR](150) NOT NULL, " +
"[ContextKey] [NVARCHAR](300) NOT NULL, " +
"[AssemblyFileName] [NVARCHAR](255) NOT NULL, " +
"[Binaries] [VARBINARY](MAX) NOT NULL, " +
"[Hashes] [VARBINARY](MAX) NOT NULL, " +
"[DeployerVersion] [NVARCHAR](32) NOT NULL, " +
"CONSTRAINT[PK___DeploymentHistory] PRIMARY KEY CLUSTERED " +
"(" +
"[DeploymentId] ASC " +
")) " +
"END";
using (var command = connection.CreateCommand())
{
command.CommandText = string.Format(sql, schemaName);
command.ExecuteNonQuery();
}
}