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")); } }