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