public string Build(string table)
{
var columns = new List <string>();
var values = new List <string>();
foreach (var pair in fields)
{
columns.Add(pair.Key);
values.Add(ValueFormat.GenerateFormattedValueForQuery(pair.Value));
}
return($"REPLACE INTO {table} ({string.Join(", ", columns)}) VALUES ({string.Join(", ", values)})");
}
internal override string GenerateCondition()
{
return(string.Format(GenerateConditionFormat(), ValueFormat.GenerateFormattedValueForQuery(Value)));
}
internal override string GenerateCondition()
{
return($"{PrependTable()}{Column} LIKE {ValueFormat.GenerateFormattedValueForQuery(Value)}");
}
private static string ConvertValueWhereQueryCondition(object betweenFrom, object betweenTo)
{
return($"{ValueFormat.GenerateFormattedValueForQuery(betweenFrom)} AND {ValueFormat.GenerateFormattedValueForQuery(betweenTo)}");
}