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