public override void BuildQuery(IDatabaseProvider provider)
{
if (_fieldValues == null || !_fieldValues.Any())
{
return;
}
var primaryKeyValueParameter = "PrimaryKeyValue";
Builder.AppendFormat("UPDATE {0} SET {1} WHERE {2} = {3};", provider.CombineSchemaAndTable(_schema, _table), _fieldValues.Select(x => string.Format("{0} = {1}", x.Key, provider.CreateParameterName(x.Key.Replace("\"", "").Replace(" ", "_")))).Join(", "), _primaryKeyField, provider.CreateParameterName(primaryKeyValueParameter));
Parameters.Add(primaryKeyValueParameter, _primaryKeyValue);
foreach (var x in _fieldValues)
{
Parameters.Add(x.Key.Replace("\"", "").Replace(" ", "_"), x.Value);
}
}
