Associates database-specific table hints with a query.

Namespace:  Mindscape.LightSpeed.Linq
Assembly:  Mindscape.LightSpeed.Linq (in Mindscape.LightSpeed.Linq.dll)
Version: 4.0.0.0 (4.0.0.0)

Syntax

C#
public static IQueryable<T> WithTableHint<T>(
	IQueryable<T> source,
	params string[] hints
)
Visual Basic (Declaration)
Public Shared Function WithTableHint(Of T) ( _
	source As IQueryable(Of T), _
	ParamArray hints As String() _
) As IQueryable(Of T)

Parameters

source
Type: System.Linq..::.IQueryable<(Of <(T>)>)
An IQueryable<(Of <(T>)>) with which to associate the database-specific options.
hints
Type: array< System..::.String >[]()[]
The database table hints to pass to the database query planner in the hint.

Type Parameters

T
The type of the elements of source.

Return Value

An IQueryable<(Of <(T>)>) which will perform the same query, but with the specified database-specific options.

Remarks

Supported on SQL Server only.

See Also