Generates a string to limit the result set to a number of maximum results with a specified offset into the results. Expects any database-specific offset and limit adjustments to have already been performed (ex. UseMaxForLimit, OffsetStartsAtOne). Performs error checking based on the various dialect limit support options. If both parameters and fixed valeus are specified, this will use the parameter option if possible. Otherwise, it will fall back to a fixed string.

Namespace: NHibernate.Dialect
Assembly: NHibernate (in NHibernate.dll) Version: 3.2.0.4000 (3.2.0.4000)

Syntax

C#
public SqlString GetLimitString(
	SqlString queryString,
	Nullable<int> offset,
	Nullable<int> limit,
	Parameter offsetParameter,
	Parameter limitParameter
)
Visual Basic
Public Function GetLimitString ( _
	queryString As SqlString, _
	offset As Nullable(Of Integer), _
	limit As Nullable(Of Integer), _
	offsetParameter As Parameter, _
	limitParameter As Parameter _
) As SqlString
Visual C++
public:
SqlString^ GetLimitString(
	SqlString^ queryString, 
	Nullable<int> offset, 
	Nullable<int> limit, 
	Parameter^ offsetParameter, 
	Parameter^ limitParameter
)

Parameters

queryString
Type: NHibernate.SqlCommand..::..SqlString

[Missing <param name="queryString"/> documentation for "M:NHibernate.Dialect.Dialect.GetLimitString(NHibernate.SqlCommand.SqlString,System.Nullable{System.Int32},System.Nullable{System.Int32},NHibernate.SqlCommand.Parameter,NHibernate.SqlCommand.Parameter)"]

offset
Type: System..::..Nullable<(Of <(<'Int32>)>)>

[Missing <param name="offset"/> documentation for "M:NHibernate.Dialect.Dialect.GetLimitString(NHibernate.SqlCommand.SqlString,System.Nullable{System.Int32},System.Nullable{System.Int32},NHibernate.SqlCommand.Parameter,NHibernate.SqlCommand.Parameter)"]

limit
Type: System..::..Nullable<(Of <(<'Int32>)>)>

[Missing <param name="limit"/> documentation for "M:NHibernate.Dialect.Dialect.GetLimitString(NHibernate.SqlCommand.SqlString,System.Nullable{System.Int32},System.Nullable{System.Int32},NHibernate.SqlCommand.Parameter,NHibernate.SqlCommand.Parameter)"]

offsetParameter
Type: NHibernate.SqlCommand..::..Parameter

[Missing <param name="offsetParameter"/> documentation for "M:NHibernate.Dialect.Dialect.GetLimitString(NHibernate.SqlCommand.SqlString,System.Nullable{System.Int32},System.Nullable{System.Int32},NHibernate.SqlCommand.Parameter,NHibernate.SqlCommand.Parameter)"]

limitParameter
Type: NHibernate.SqlCommand..::..Parameter

[Missing <param name="limitParameter"/> documentation for "M:NHibernate.Dialect.Dialect.GetLimitString(NHibernate.SqlCommand.SqlString,System.Nullable{System.Int32},System.Nullable{System.Int32},NHibernate.SqlCommand.Parameter,NHibernate.SqlCommand.Parameter)"]

Return Value

[Missing <returns> documentation for "M:NHibernate.Dialect.Dialect.GetLimitString(NHibernate.SqlCommand.SqlString,System.Nullable{System.Int32},System.Nullable{System.Int32},NHibernate.SqlCommand.Parameter,NHibernate.SqlCommand.Parameter)"]

See Also