protected override Command LimitClause(SelectLimit limit) { //Validating arguments if (limit == null) return null; return "TOP " + limit.Count; }
/// <summary> /// Creates the Limit clause for a Select sql sentence, used for paging /// </summary> /// <param name="limit"> /// Starting and finishing indexes that define the subgroup of Objects retrieved by the select operation /// </param> /// <returns> /// Limit clause for a Select sql sentence /// </returns> protected virtual Command LimitClause(SelectLimit limit) { //Validating arguments if (limit == null) return null; return "LIMIT " + limit.From + ", " + limit.To; }