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