public override string FormatSelectLimit(SqlTable table, SqlColumn[] columns, SqlJoin[] joins, SqlCondition where, SqlOrder order, int limit, SqlSelectOptions options)
{
SqlStatement s = "select";
if (options.HasFlag(SqlSelectOptions.Distinct))
{
s += "distinct";
}
s += $"top {limit} {FormatColumn(columns)}";
s += FormatFrom(table);
s += FormatJoin(joins);
s += FormatWhere(where);
s += FormatOrder(order);
return(s);
}
internal SqlSelectProto(Sql database, SqlSelectOptions options, params SqlColumn[] columns) : base(database)
{
Options = options;
SelectColumns = columns.Length == 0 ? null : columns;
}
