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