public void EnsureSchema(DatabaseContext context)
{
var sql = string.Format(@"
SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = '{0}'
", _tableName);
var properties = context.ExecuteQuery(sql);
if (properties.Count == 0)
{
var newSchemaSql = string.Format(@"
CREATE TABLE [dbo].[{0}]
(
[MigrationVersion] int NOT NULL,
CONSTRAINT PK_MigrationVersion PRIMARY KEY CLUSTERED ([MigrationVersion])
);
INSERT INTO [dbo].[{0}] VALUES('0');
",
_tableName);
context.ExecuteNonQuery(newSchemaSql);
}
}
public int GetDatabaseVersionNumber(DatabaseContext context)
{
var versionProperty = context.ExecuteQuery(string.Format("select * from sys.extended_properties where [class] = 0 and [name] = '{0}'", ExtProp.DatabaseVersion))
.Single();
var currentVersion = int.Parse(versionProperty["value"].ToString());
return currentVersion;
}
public void EnsureSchema(DatabaseContext context)
{
var sql = string.Format("select * from sys.extended_properties where [class] = 0 and [name] = '{0}'", ExtProp.DatabaseVersion);
var properties = context.ExecuteQuery(sql);
if (properties.Count == 0)
{
context.ExecuteNonQuery(string.Format("exec sys.sp_addextendedproperty @name=N'{0}', @value=N'{1}'", ExtProp.DatabaseVersion, "0"));
}
}
