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