public override void ToString(StringBuilder buf, int indent) { Expression.ToString(buf, indent); if (NotDefined) { buf.Append(" NOT IN ("); } else { buf.Append(" IN ("); } if (Subquery != null) { Subquery.ToString(buf, Sql150ScriptGenerator.GetCurrentIndent(buf)); } else { for (var i = 0; i < Values.Count; i++) { if (i > 0) { buf.Append(", "); } Values[i].ToString(buf, indent); } } buf.Append(")"); }
public override void ToString(StringBuilder buf, int indent) { buf.Append(' ', indent); var longestClause = "SELECT"; if (GroupByClause != null) { longestClause = "GROUP BY"; } else if (OrderByClause != null) { longestClause = "ORDER BY"; } buf.Append("SELECT"); buf.Append(' ', longestClause.Length - "SELECT".Length + 1); if (UniqueRowFilter == UniqueRowFilter.Distinct) { buf.Append("DISTINCT "); } TopRowFilter?.ToString(buf, indent); var selectIndent = Sql150ScriptGenerator.GetCurrentIndent(buf); for (var i = 0; i < SelectElements.Count; i++) { if (i > 0) { buf.Append(",\r\n"); buf.Append(' ', selectIndent); } SelectElements[i].ToString(buf, selectIndent); } buf.Append("\r\n"); FromClause?.ToString(buf, indent, longestClause.Length); WhereClause?.ToString(buf, indent, longestClause.Length); GroupByClause?.ToString(buf, indent, longestClause.Length); OrderByClause?.ToString(buf, indent, longestClause.Length); OffsetClause?.ToString(buf, indent, longestClause.Length); }
public override void ToString(StringBuilder buf, int indent) { buf.Append("("); Expression.ToString(buf, Sql150ScriptGenerator.GetCurrentIndent(buf)); buf.Append(")"); }