Пример #1
0
		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;
		}