Exemplo n.º 1
0
        protected override Command LimitClause(SelectLimit limit)
        {
            //Validating arguments
            if (limit == null)
            {
                return(null);
            }

            return("TOP " + limit.Count);
        }
Exemplo n.º 2
0
        /// <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);
        }