private static void CreateVersionTable() { if (!DatabaseManager.TableExists("poscuba_info")) { string sqlTable = @"CREATE TABLE poscuba_info( db_version CHAR(10));"; string sqlVersion = @"INSERT INTO poscuba_info (db_version) VALUES ('1.02') "; try { DatabaseManager.executeSQL(sqlTable); DatabaseManager.executeSQL(sqlVersion); dataBaseVersion = "1.02"; } catch (Exception e) { MigrationError = e.Message; } } } public static string GetDBVersion() { string version = ""; try { version = (string)DatabaseManager.executeScalar("Select db_version from poscuba_info"); if (version == "") { MigrationError = "Version not found"; } } catch (Exception e) { MigrationError = e.Message; } dataBaseVersion = version.Trim(); return dataBaseVersion; }
if (string.IsNullOrEmpty(version))
executeScalar
DatabaseManager
DatabaseManager.executeSQL(sqlTable); Thread.Sleep(1000); // add a 1s wait here DatabaseManager.executeSQL(sqlVersion);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)