private static Versioning.Version GetFirstVersionInVersionsTable(Database database) { const string LAST_VERSION_COMMAND = "Select top 1 VersionNumber from Version order by Date desc"; string lastVersion = database.Database.SqlQuery <string>(LAST_VERSION_COMMAND).FirstOrDefault(); var parser = new Versioning.JustVersionParser(); return(parser.Parse(lastVersion)); }
internal static void UpgradeDatabaseVersion() { string connectionString = settings.ConnectionString; string databaseMasterPassword = settings.DatabaseMasterPassword; DatabaseValidationResult dbResult = ValidateDatabaseConnection(connectionString, databaseMasterPassword); string migrationsRoot = FileLocations.SqlMigrations; if (Directory.Exists(migrationsRoot)) { var parser = new Versioning.JustVersionParser(); var list = SqlScriptRunner.ScriptRunner.ResolveScriptsFromPathAndVersion(migrationsRoot, "*.sql", true, migrationsRoot, dbResult.CurrentVersion, Versioning.Version.Max, parser); // commit the database upgrade in next version } }
internal static void UpgradeDatabaseVersion() { string connectionString = settings.ConnectionString; string databaseMasterPassword = settings.DatabaseMasterPassword; DatabaseValidationResult dbResult = ValidateDatabaseConnection(connectionString, databaseMasterPassword); string migrationsRoot = FileLocations.SqlMigrations; if (Directory.Exists(migrationsRoot)) { var parser = new Versioning.JustVersionParser(); var list = SqlScriptRunner.ScriptRunner.ResolveScriptsFromPathAndVersion(migrationsRoot, "*.sql", true, migrationsRoot, dbResult.CurrentVersion, Versioning.Version.Max, parser); // commit the database upgrade in next version } }
private static Versioning.Version GetFirstVersionInVersionsTable(Database database) { const string LAST_VERSION_COMMAND = "Select top 1 VersionNumber from Version order by Date desc"; string lastVersion = database.Database.SqlQuery<string>(LAST_VERSION_COMMAND).FirstOrDefault(); var parser = new Versioning.JustVersionParser(); return parser.Parse(lastVersion); }