コード例 #1
0
        /// <summary>
        /// Gets an interval of time.
        /// </summary>
        /// <param name="interval">The unit of time.</param>
        /// <param name="value">The amount of time.</param>
        /// <returns>The SQL string for the function.</returns>
        /// <exception cref="ArgumentOutOfRangeException"><paramref name="interval"/> is not a defined <see cref="QueryIntervalType"/>
        /// value.</exception>
        public string Interval(QueryIntervalType interval, int value)
        {
            if (!EnumHelper <QueryIntervalType> .IsDefined(interval))
            {
                throw new ArgumentOutOfRangeException("interval");
            }

            return("INTERVAL " + value + " " + interval.ToString().ToUpper());
        }
コード例 #2
0
        /// <summary>
        /// Gets an interval of time.
        /// </summary>
        /// <param name="interval">The unit of time.</param>
        /// <param name="value">The amount of time.</param>
        /// <returns>The SQL string for the function.</returns>
        /// <exception cref="ArgumentOutOfRangeException"><paramref name="interval"/> is not a defined <see cref="QueryIntervalType"/>
        /// value.</exception>
        /// <exception cref="ArgumentNullException"><paramref name="value"/> is null or empty.</exception>
        public string Interval(QueryIntervalType interval, string value)
        {
            if (!EnumHelper<QueryIntervalType>.IsDefined(interval))
                throw new ArgumentOutOfRangeException("interval");
            if (string.IsNullOrEmpty(value))
                throw new ArgumentNullException("value");

            return "INTERVAL " + value + " " + interval.ToString().ToUpper();
        }