public DbCommand BuildUpdateCommand(DbProviderFactoryAdapter provider, object data, object keyData, Core.SQL.OnConflictOption option)
{
Debug.Assert(data != null);
Debug.Assert(EntityDescription.Fields.PrimaryKeyField != null);
DbCommand command = provider.CreateCommand();
var columnNames = new List<string>();
var columnExpressions = new List<string>();
foreach (FieldAttribute field in EntityDescription.Fields.GetPersistedFields(true, PersistanceFlags.OnUpdate))
{
columnNames.Add(field.Name);
columnExpressions.Add(field.SQLPramName);
object value = field.GetFieldValueOrDefault(data);
DbParameter pram = provider.CreateParameter(field.SQLPramName, value);
command.Parameters.Add(pram);
}
PrimaryKeyFieldAttribute keyField = EntityDescription.Fields.PrimaryKeyField;
DbParameter p = provider.CreateParameter(keyField.SQLPramName, keyData);
command.Parameters.Add(p);
var where = new WhereClause(keyField.Name + " = " + keyField.SQLPramName);
var expression = new SQLUpdateCommand()
{
TableName = EntityDescription.SourceName,
ColumnNames = columnNames,
ValueExpressions = columnExpressions,
ConflictOption = option,
Where = where
};
command.CommandText = expression.ToString();
return command;
}
public void Accept(WhereClause whereClause)
{
whereClause.Accept(null);
this.Clause = whereClause;
}
