public async Task UpdateGroup(string oldGroupName, string newGroupName) { using (var conn = new SQLiteConnection(_connectionString)) { conn.Open(); var oldGroup = await GetGroupWithConnection(conn, oldGroupName.ToUpper()); var cmdUpdate = new SQLiteCommand(SQLQueries.UpdateGroup(), conn); cmdUpdate.Parameters.Add(new SQLiteParameter("@Group", newGroupName.ToUpper())); cmdUpdate.Parameters.Add(new SQLiteParameter("@GroupID", oldGroup.ID)); await cmdUpdate.ExecuteNonQueryAsync(); } }