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(); }