/// <summary> /// Generates a SQL SET clause based on the dictionary passed /// </summary> /// <param name="config"></param> /// <param name="columnNamessAndSqlFormattedValues"></param> /// <returns></returns> public static string GetSetClause(SqlGeneratorConfig config, Dictionary <string, string> columnNamessAndSqlFormattedValues) { if (config.FormatSqlText) { return("SET " + string.Join(", ", columnNamessAndSqlFormattedValues.Select(a => $"{config.GetFormattedColumnIdentifier(a.Key)} = {a.Value}")) + Environment.NewLine + "\t"); } else { return("SET " + string.Join(", ", columnNamessAndSqlFormattedValues.Select(a => $"{config.GetFormattedColumnIdentifier(a.Key)} = {a.Value}"))); } }
/// <summary> /// Generates a SQL WHERE clause based on the dictionary passed /// </summary> /// <param name="config"></param> /// <param name="columnNamessAndSqlFormattedValues"></param> /// <returns></returns> public static string GetWhereClause(SqlGeneratorConfig config, Dictionary <string, string> columnNamessAndSqlFormattedValues) { return("WHERE " + string.Join(" AND ", columnNamessAndSqlFormattedValues.Select(a => $"{config.GetFormattedColumnIdentifier(a.Key)} = {a.Value}"))); }