protected override DbExpression VisitUpdateExpression(DbUpdateExpression updateExpression)
{
var sb = new StringBuilder();
if (updateExpression.FromExpression.IsNull())
sb.AppendFormat("UPDATE {0} ", Visit(updateExpression.Target));
else
sb.AppendFormat("UPDATE {0} ", Visit(updateExpression.FromExpression));
if (!updateExpression.SetExpression.IsNull())
{
sb.AppendLine();
sb.AppendFormat("SET {0} ", Visit(updateExpression.SetExpression));
}
if (!updateExpression.WhereExpression.IsNull())
{
sb.AppendLine();
sb.AppendLine("WHERE ");
sb.AppendFormat(1, "{0} ", Visit(updateExpression.WhereExpression));
}
return ExpressionFactory.Sql(sb.ToString().Trim());
}