/// <summary> /// Execute an UPDATE query. /// </summary> /// <param name="tableName">The table in which you wish to UPDATE.</param> /// <param name="keyValuePairs">The key-value pairs for the data you wish to UPDATE.</param> /// <param name="filter">The expression containing the UPDATE filter (i.e. WHERE clause data).</param> public void Update(string tableName, Dictionary <string, object> keyValuePairs, Expression filter) { if (String.IsNullOrEmpty(tableName)) { throw new ArgumentNullException(nameof(tableName)); } if (keyValuePairs == null || keyValuePairs.Count < 1) { throw new ArgumentNullException(nameof(keyValuePairs)); } #region Build-Key-Value-Clause string keyValueClause = ""; int added = 0; foreach (KeyValuePair <string, object> curr in keyValuePairs) { if (String.IsNullOrEmpty(curr.Key)) { continue; } if (added == 0) { if (curr.Value != null) { if (curr.Value is DateTime || curr.Value is DateTime?) { keyValueClause += MysqlHelper.PreparedFieldname(curr.Key) + "='" + DbTimestamp((DateTime)curr.Value) + "'"; } else if (curr.Value is int || curr.Value is long || curr.Value is decimal) { keyValueClause += MysqlHelper.PreparedFieldname(curr.Key) + "=" + curr.Value.ToString(); } else { if (Helper.IsExtendedCharacters(curr.Value.ToString())) { keyValueClause += MysqlHelper.PreparedFieldname(curr.Key) + "=" + MysqlHelper.PreparedUnicodeValue(curr.Value.ToString()); } else { keyValueClause += MysqlHelper.PreparedFieldname(curr.Key) + "=" + MysqlHelper.PreparedStringValue(curr.Value.ToString()); } } } else { keyValueClause += MysqlHelper.PreparedFieldname(curr.Key) + "= null"; } } else { if (curr.Value != null) { if (curr.Value is DateTime || curr.Value is DateTime?) { keyValueClause += "," + MysqlHelper.PreparedFieldname(curr.Key) + "='" + DbTimestamp((DateTime)curr.Value) + "'"; } else if (curr.Value is int || curr.Value is long || curr.Value is decimal) { keyValueClause += "," + MysqlHelper.PreparedFieldname(curr.Key) + "=" + curr.Value.ToString(); } else { if (Helper.IsExtendedCharacters(curr.Value.ToString())) { keyValueClause += "," + MysqlHelper.PreparedFieldname(curr.Key) + "=" + MysqlHelper.PreparedUnicodeValue(curr.Value.ToString()); } else { keyValueClause += "," + MysqlHelper.PreparedFieldname(curr.Key) + "=" + MysqlHelper.PreparedStringValue(curr.Value.ToString()); } } } else { keyValueClause += "," + MysqlHelper.PreparedFieldname(curr.Key) + "= null"; } } added++; } #endregion #region Build-UPDATE-Query-and-Submit Query(MysqlHelper.UpdateQuery(tableName, keyValueClause, filter)); #endregion }