protected virtual string GetStatementSql (UpdateStatement statement)
{
StringBuilder sb = new StringBuilder ();
sb.Append ("UPDATE ");
sb.Append (GetSql (statement.Identifier));
sb.Append (' ');
sb.Append (Environment.NewLine);
sb.Append ("SET ");
int columnCount = statement.Columns.Count;
for (int i=0; i<columnCount; i++) {
OperatorExpression expr = new OperatorExpression (statement.Columns[i], Operator.Equals, statement.Values[i]);
sb.Append (GetExpressionSql (expr));
sb.Append (i != (columnCount - 1) ? ", " : "");
}
if (statement.Where != null) {
sb.Append (GetSql (statement.Where));
sb.Append (' ');
sb.Append (Environment.NewLine);
}
sb.Append (';');
return sb.ToString ();
}
protected virtual string GetExpressionSql (OperatorExpression expr)
{
return String.Concat ("(", GetSql (expr.Left), " ",
GetOperatorSql (expr.Operator), " ",
GetSql (expr.Right), ")");
}
protected virtual string GetExpressionSql(OperatorExpression expr)
{
return(String.Concat("(", GetSql(expr.Left), " ",
GetOperatorSql(expr.Operator), " ",
GetSql(expr.Right), ")"));
}