/// <summary> /// Create long_operations_status table /// </summary> /// <param name="connection"></param> private static void CreateLongOperationsStatusTable(DBHelper db) { var sb = new StringBuilder(); sb.Append("CREATE TABLE IF NOT EXISTS ").Append(LongOperationsStatusTable).Append(" (") .Append(IdCol).Append(" INTEGER PRIMARY KEY AUTOINCREMENT") .Append(",").Append(TypeCol).Append(" TEXT") .Append(",").Append(DetailsCol).Append(" TEXT") .Append(",").Append(StatusCol).Append(" TEXT") .Append(", ").Append(CreatedCol).Append(" INTEGER") .Append(", ").Append(LastModifiedCol).Append(" INTEGER") .Append(")"); db.Execute(sb.ToString()); }
public static DBHelper GetInstance(string sqliteDbFile) { if (_instances == null) { _instances = new Dictionary<string, DBHelper>(); } DBHelper instance; if (!_instances.TryGetValue(sqliteDbFile, out instance)) { instance = new DBHelper(sqliteDbFile); _instances.Add(sqliteDbFile, instance); } return instance; }