/// <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}"))); }