//public static int AddSchemaVersion( // Guid applicationID, // string applicationName, // int major, // int minor, // int build, // int revision) //{ // return dbPortal.SchemaVersion_AddSchemaVersion( // applicationID, // applicationName, // major, // minor, // build, // revision); //} public static bool UpdateSchemaVersion( Guid applicationId, string applicationName, int major, int minor, int build, int revision) { if (!DBPortal.SchemaVersionExists(applicationId)) { return(DBPortal.SchemaVersionAddSchemaVersion( applicationId, applicationName, major, minor, build, revision)); } return(DBPortal.SchemaVersionUpdateSchemaVersion( applicationId, applicationName, major, minor, build, revision)); }
public static Version DBSchemaVersion() { // this should never change // its the last version before auto upgrades int major = 2; int minor = 2; int build = 1; int revision = 4; bool found = false; try { using (IDataReader reader = DBPortal.SchemaVersionGetSchemaVersion(GetApplicationId())) { if (reader.Read()) { major = Convert.ToInt32(reader["Major"]); minor = Convert.ToInt32(reader["Minor"]); build = Convert.ToInt32(reader["Build"]); revision = Convert.ToInt32(reader["Revision"]); found = true; } } if (!found) { DBPortal.SchemaVersionAddSchemaVersion( GetApplicationId(), GetApplicationName(), major, minor, build, revision); } } catch (DbException) { } catch (InvalidOperationException) { } return(new Version(major, minor, build, revision)); }