protected override void AppendTo(SqlStringBuilder builder)
{
// TODO: Flags ...
builder.AppendFormat("CURSOR {0}", CursorName);
if (Parameters != null)
{
var pars = Parameters.ToArray();
builder.Append("(");
for (int i = 0; i < pars.Length; i++)
{
pars[i].AppendTo(builder);
if (i < pars.Length - 1)
{
builder.Append(", ");
}
}
builder.Append(")");
}
builder.Append(" IS");
builder.AppendLine();
builder.Indent();
QueryExpression.AppendTo(builder);
builder.DeIndent();
}
protected override void AppendTo(SqlStringBuilder builder)
{
string ifNotExists = ReplaceIfExists ? "IF NOT EXISTS " : "";
builder.AppendFormat("CREATE {0}VIEW ", ifNotExists);
ViewName.AppendTo(builder);
if (ColumnNames != null)
{
var colNames = String.Join(", ", ColumnNames.ToArray());
builder.AppendFormat("({0})", colNames);
}
builder.Append(" IS");
builder.AppendLine();
builder.Indent();
QueryExpression.AppendTo(builder);
builder.DeIndent();
}