Class SqlHints

Namespace

CMS.DataEngine

Assembly

CMS.DataEngine.dll

Provides SQL hints

public class SqlHints

Inheritance

object

SqlHints

Extension Methods

DataExtensions.With<T>(T, Action<T>)

QueryExtensions.AsLiteral<T>(T)

QueryExtensions.AsValue<T>(T, bool)

Constructors

SqlHints()

public SqlHints()

Fields

NOEXPAND

Specifies that any indexed views are not expanded to access underlying tables when the query optimizer processes the query. The query optimizer treats the view like a table with clustered index. NOEXPAND applies only to indexed views.

public const string NOEXPAND = "NOEXPAND"

Field Value

string

NOLOCK

Specifies that the query can read the uncommitted data and ignores the locks.

public const string NOLOCK = "NOLOCK"

Field Value

string

Methods

GetTableHints(params string[])

Gets the table hints for the query

public static string GetTableHints(params string[] hints)

Parameters

hints string[]

List of hints to include

Returns

string