public void Save(string[] columns, object[] values) { if (columns.Length < 1 || columns.Length != values.Length) { return; } string query = "UPDATE rooms SET "; MySqlParameter[] parameters = new MySqlParameter[columns.Length + 1]; for (int i = 0; i < columns.Length && i < values.Length; i++) { if (i > 0) { query += ", "; } query += $"{columns[i]} = @{columns[i]}"; parameters[i] = new MySqlParameter($"@{columns[i]}", values[i]); } query += " WHERE id = @roomId"; parameters[parameters.Length - 1] = new MySqlParameter("@roomId", Id); using (DatabaseConnection dbConnection = Engine.Locator.ConnectionPool.PopConnection()) { dbConnection.SetQuery(query); dbConnection.AddParameters(parameters); dbConnection.Execute(); } }