protected override void AppendTo(SqlStringBuilder builder) { var orReplace = ReplaceIfExists ? "OR REPLACE" : ""; builder.AppendFormat("CREATE {0}FUNCTION ", orReplace); FunctionName.AppendTo(builder); builder.Append("("); if (Parameters != null && Parameters.Length > 0) { for (int i = 0; i < Parameters.Length; i++) { Parameters[i].AppendTo(builder); if (i < Parameters.Length - 1) { builder.Append(", "); } } } builder.Append(")"); builder.Append(" RETURN "); ReturnType.AppendTo(builder); builder.AppendLine(" IS"); builder.Indent(); Body.AppendTo(builder); builder.DeIndent(); }
protected override void AppendTo(SqlStringBuilder builder) { FunctionName.AppendTo(builder); builder.Append("("); for (int i = 0; i < Arguments.Length; i++) { Arguments[i].AppendTo(builder); if (i < Arguments.Length - 1) { builder.Append(", "); } } builder.Append(")"); }