private void Initialize() { var dataFileName = PathUtil.GetAppPath("user_data.db"); if (!System.IO.File.Exists(dataFileName)) { CreatePasswordDatabase(dataFileName); } this.DatabaseManager = new DatabaseManager(QueryFactoryBuilder.BuildForSqlite(dataFileName)); }
private void CreatePasswordDatabase(string dataFileName) { SQLiteConnection.CreateFile(dataFileName); var db = QueryFactoryBuilder.BuildForSqlite(dataFileName); db.Connection.Open(); var statement = "CREATE TABLE \"crendentials\"(" + "\"id\" INTEGER NOT NULL UNIQUE," + "\"title\" TEXT NOT NULL," + "\"location\" TEXT," + "\"username\" TEXT NOT NULL," + "\"password\" TEXT NOT NULL," + "PRIMARY KEY(\"id\" AUTOINCREMENT)" + ");"; var cmd = new SQLiteCommand(statement, (SQLiteConnection)db.Connection); cmd.ExecuteNonQuery(); db.Connection.Close(); }