Example #1
0
        /// <summary>
        /// Begins a new SELECT DISTINCT statement. Add fields and tables by using the methods on the instance returned
        /// </summary>
        /// <returns>A new DBSelectQuery to support statement chaining</returns>
        public static DBSelectQuery SelectDistinct()
        {
            DBSelectQuery q = DBQuery.Select();

            return(q.Distinct());
        }
Example #2
0
        /// <summary>
        /// Begins a new SELECT statement with a limit of [count] items returned
        /// </summary>
        /// <param name="count">The total number of items to return</param>
        /// <returns>A new DBSelectQuery to support statement chaining</returns>
        public static DBSelectQuery SelectTopN(int count)
        {
            DBSelectQuery q = DBQuery.Select();

            return(q.TopN(count));
        }