Class SqlServerHints

Namespace

LinqToDB.DataProvider.SqlServer

Assembly

linq2db.dll

https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql

public static class SqlServerHints

Inheritance

object

SqlServerHints

Methods

JoinHashHint<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("JoinHashHintImpl")]
public static ISqlServerSpecificQueryable<TSource> JoinHashHint<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

JoinHashHint<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("JoinHashTableHintImpl")]
public static ISqlServerSpecificTable<TSource> JoinHashHint<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

JoinHint<TSource>(ISqlServerSpecificQueryable<TSource>, string)

Adds a join hint to a generated query.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.JoinHint, typeof(NoneExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> JoinHint<TSource>(this ISqlServerSpecificQueryable<TSource> source, string hint) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

JoinHint<TSource>(ISqlServerSpecificTable<TSource>, string)

Adds a join hint to a generated query.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.JoinHint, typeof(NoneExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificTable<TSource> JoinHint<TSource>(this ISqlServerSpecificTable<TSource> table, string hint) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Table-like query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificTable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

JoinLoopHint<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("JoinLoopHintImpl")]
public static ISqlServerSpecificQueryable<TSource> JoinLoopHint<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

JoinLoopHint<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("JoinLoopTableHintImpl")]
public static ISqlServerSpecificTable<TSource> JoinLoopHint<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

JoinMergeHint<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("JoinMergeHintImpl")]
public static ISqlServerSpecificQueryable<TSource> JoinMergeHint<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

JoinMergeHint<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("JoinMergeTableHintImpl")]
public static ISqlServerSpecificTable<TSource> JoinMergeHint<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

JoinRemoteHint<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("JoinRemoteHintImpl")]
public static ISqlServerSpecificQueryable<TSource> JoinRemoteHint<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

JoinRemoteHint<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("JoinRemoteTableHintImpl")]
public static ISqlServerSpecificTable<TSource> JoinRemoteHint<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

OptionConcatUnion<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionConcatUnionImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionConcatUnion<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionDisableExternalPushDown<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionDisableExternalPushDownImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionDisableExternalPushDown<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionDisableScaleOutExecution<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionDisableScaleOutExecutionImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionDisableScaleOutExecution<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionExpandViews<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionExpandViewsImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionExpandViews<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionFast<TSource>(ISqlServerSpecificQueryable<TSource>, int)

[ExpressionMethod("OptionFastImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionFast<TSource>(this ISqlServerSpecificQueryable<TSource> query, int value) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

value int

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionForceExternalPushDown<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionForceExternalPushDownImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionForceExternalPushDown<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionForceOrder<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionForceOrderImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionForceOrder<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionForceScaleOutExecution<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionForceScaleOutExecutionImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionForceScaleOutExecution<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionHashGroup<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionHashGroupImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionHashGroup<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionHashJoin<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionHashJoinImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionHashJoin<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionHashUnion<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionHashUnionImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionHashUnion<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionIgnoreNonClusteredColumnStoreIndex<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionIgnoreNonClusteredColumnStoreIndexImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionIgnoreNonClusteredColumnStoreIndex<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionKeepFixedPlan<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionKeepFixedPlanImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionKeepFixedPlan<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionKeepPlan<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionKeepPlanImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionKeepPlan<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionLoopJoin<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionLoopJoinImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionLoopJoin<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionMaxDop<TSource>(ISqlServerSpecificQueryable<TSource>, int)

[ExpressionMethod("OptionMaxDopImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionMaxDop<TSource>(this ISqlServerSpecificQueryable<TSource> query, int value) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

value int

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionMaxGrantPercent<TSource>(ISqlServerSpecificQueryable<TSource>, int)

[ExpressionMethod("OptionMaxGrantPercentImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionMaxGrantPercent<TSource>(this ISqlServerSpecificQueryable<TSource> query, int value) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

value int

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionMaxRecursion<TSource>(ISqlServerSpecificQueryable<TSource>, int)

[ExpressionMethod("OptionMaxRecursionImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionMaxRecursion<TSource>(this ISqlServerSpecificQueryable<TSource> query, int value) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

value int

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionMergeJoin<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionMergeJoinImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionMergeJoin<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionMergeUnion<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionMergeUnionImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionMergeUnion<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionMinGrantPercent<TSource>(ISqlServerSpecificQueryable<TSource>, int)

[ExpressionMethod("OptionMinGrantPercentImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionMinGrantPercent<TSource>(this ISqlServerSpecificQueryable<TSource> query, int value) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

value int

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionNoPerformanceSpool<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionNoPerformanceSpoolImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionNoPerformanceSpool<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionOptimizeForUnknown<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionOptimizeForUnknownImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionOptimizeForUnknown<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionOptimizeFor<TSource>(ISqlServerSpecificQueryable<TSource>, params string[])

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.ParamsExtensionBuilder), "OPTIMIZE FOR")]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> OptionOptimizeFor<TSource>(this ISqlServerSpecificQueryable<TSource> source, params string[] values) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

values string[]

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionOrderGroup<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionOrderGroupImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionOrderGroup<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionQueryTraceOn<TSource>(ISqlServerSpecificQueryable<TSource>, int)

[ExpressionMethod("OptionQueryTraceOnImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionQueryTraceOn<TSource>(this ISqlServerSpecificQueryable<TSource> query, int value) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

value int

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionRecompile<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionRecompileImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionRecompile<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionRobustPlan<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("OptionRobustPlanImpl")]
public static ISqlServerSpecificQueryable<TSource> OptionRobustPlan<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionTableHint<TSource>(ISqlServerSpecificQueryable<TSource>, SqlID, params string[])

[Sql.QueryExtension("SqlServer.2008", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.TableParamsExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2012", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.TableParamsExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2014", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.TableParamsExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2016", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.TableParamsExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2017", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.TableParamsExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2019", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.TableParamsExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2022", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.TableParamsExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> OptionTableHint<TSource>(this ISqlServerSpecificQueryable<TSource> source, Sql.SqlID tableID, params string[] values) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

tableID Sql.SqlID

values string[]

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

OptionUseHint<TSource>(ISqlServerSpecificQueryable<TSource>, params string[])

[Sql.QueryExtension("SqlServer.2017", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.ParamsExtensionBuilder), "USE HINT")]
[Sql.QueryExtension("SqlServer.2019", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.ParamsExtensionBuilder), "USE HINT")]
[Sql.QueryExtension("SqlServer.2022", Sql.QueryExtensionScope.QueryHint, typeof(SqlServerHints.ParamsExtensionBuilder), "USE HINT")]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> OptionUseHint<TSource>(this ISqlServerSpecificQueryable<TSource> source, params string[] values) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

values string[]

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

QueryHint2008Plus<TSource>(ISqlServerSpecificQueryable<TSource>, string)

Adds a query hint to a generated query.

[Sql.QueryExtension("SqlServer.2008", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2012", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2014", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2016", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2017", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2019", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2022", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> QueryHint2008Plus<TSource>(this ISqlServerSpecificQueryable<TSource> source, string hint) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

QueryHint2012Plus<TSource>(ISqlServerSpecificQueryable<TSource>, string)

Adds a query hint to a generated query.

[Sql.QueryExtension("SqlServer.2012", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2014", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2016", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2017", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2019", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2022", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> QueryHint2012Plus<TSource>(this ISqlServerSpecificQueryable<TSource> source, string hint) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

QueryHint2016Plus<TSource>(ISqlServerSpecificQueryable<TSource>, string)

Adds a query hint to a generated query.

[Sql.QueryExtension("SqlServer.2016", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2017", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2019", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2022", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> QueryHint2016Plus<TSource>(this ISqlServerSpecificQueryable<TSource> source, string hint) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

QueryHint2019Plus<TSource>(ISqlServerSpecificQueryable<TSource>, string)

Adds a query hint to a generated query.

[Sql.QueryExtension("SqlServer.2019", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2022", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> QueryHint2019Plus<TSource>(this ISqlServerSpecificQueryable<TSource> source, string hint) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

QueryHint<TSource>(ISqlServerSpecificQueryable<TSource>, string)

Adds a query hint to a generated query.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.QueryHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> QueryHint<TSource>(this ISqlServerSpecificQueryable<TSource> source, string hint) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

QueryHint<TSource, TParam>(ISqlServerSpecificQueryable<TSource>, string, TParam)

Adds a query hint to the generated query.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.QueryHint, typeof(HintWithParameterExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> QueryHint<TSource, TParam>(this ISqlServerSpecificQueryable<TSource> source, string hint, TParam hintParameter) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

hintParameter TParam

Hint parameter.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TParam

Hint parameter type

QueryHint<TSource, TParam>(ISqlServerSpecificQueryable<TSource>, string, params TParam[])

Adds a query hint to the generated query.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.QueryHint, typeof(HintWithParametersExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> QueryHint<TSource, TParam>(this ISqlServerSpecificQueryable<TSource> source, string hint, params TParam[] hintParameters) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

hintParameters TParam[]

Table hint parameters.

Returns

ISqlServerSpecificQueryable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

TableHint2012Plus<TSource>(ISqlServerSpecificTable<TSource>, string)

[Sql.QueryExtension("SqlServer.2012", Sql.QueryExtensionScope.TableHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2014", Sql.QueryExtensionScope.TableHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2016", Sql.QueryExtensionScope.TableHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2017", Sql.QueryExtensionScope.TableHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2019", Sql.QueryExtensionScope.TableHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2022", Sql.QueryExtensionScope.TableHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificTable<TSource> TableHint2012Plus<TSource>(this ISqlServerSpecificTable<TSource> table, string hint) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

hint string

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

TableHint<TSource>(ISqlServerSpecificTable<TSource>, string)

Adds a table hint to a table in generated query.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.TableHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificTable<TSource> TableHint<TSource>(this ISqlServerSpecificTable<TSource> table, string hint) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Table-like query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TableHint<TSource, TParam>(ISqlServerSpecificTable<TSource>, string, TParam)

Adds a table hint to a table in generated query.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.TableHint, typeof(HintWithParameterExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificTable<TSource> TableHint<TSource, TParam>(this ISqlServerSpecificTable<TSource> table, string hint, TParam hintParameter) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Table-like query source.

hint string

SQL text, added as a database specific hint to generated query.

hintParameter TParam

Table hint parameter.

Returns

ISqlServerSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

TableHint<TSource, TParam>(ISqlServerSpecificTable<TSource>, string, params TParam[])

Adds a table hint to a table in generated query.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.TableHint, typeof(HintWithParametersExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificTable<TSource> TableHint<TSource, TParam>(this ISqlServerSpecificTable<TSource> table, string hint, params TParam[] hintParameters) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Table-like query source.

hint string

SQL text, added as a database specific hint to generated query.

hintParameters TParam[]

Table hint parameters.

Returns

ISqlServerSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

TablesInScopeHint2012Plus<TSource>(ISqlServerSpecificQueryable<TSource>, string)

Adds a table hint to all the tables in the method scope.

[Sql.QueryExtension("SqlServer.2012", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2014", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2016", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2017", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2019", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2022", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> TablesInScopeHint2012Plus<TSource>(this ISqlServerSpecificQueryable<TSource> source, string hint) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TablesInScopeHint2014Plus<TSource>(ISqlServerSpecificQueryable<TSource>, string)

Adds a table hint to all the tables in the method scope.

[Sql.QueryExtension("SqlServer.2014", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2016", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2017", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2019", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension("SqlServer.2022", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> TablesInScopeHint2014Plus<TSource>(this ISqlServerSpecificQueryable<TSource> source, string hint) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TablesInScopeHint<TSource>(ISqlServerSpecificQueryable<TSource>, string)

Adds a table hint to all the tables in the method scope.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> TablesInScopeHint<TSource>(this ISqlServerSpecificQueryable<TSource> source, string hint) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TablesInScopeHint<TSource>(ISqlServerSpecificQueryable<TSource>, string, params object[])

Adds a table hint to all the tables in the method scope.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintWithParametersExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> TablesInScopeHint<TSource>(this ISqlServerSpecificQueryable<TSource> source, string hint, params object[] hintParameters) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

hintParameters object[]

Table hint parameters.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TablesInScopeHint<TSource, TParam>(ISqlServerSpecificQueryable<TSource>, string, TParam)

Adds a table hint to all the tables in the method scope.

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.TablesInScopeHint, typeof(HintWithParameterExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificQueryable<TSource> TablesInScopeHint<TSource, TParam>(this ISqlServerSpecificQueryable<TSource> source, string hint, TParam hintParameter) where TSource : notnull

Parameters

source ISqlServerSpecificQueryable<TSource>

Query source.

hint string

SQL text, added as a database specific hint to generated query.

hintParameter TParam

Table hint parameter.

Returns

ISqlServerSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

TemporalTableAll<TSource>(ISqlServerSpecificTable<TSource>)

See Temporal table

Expression
ALL
Qualifying Rows
All rows
Note
Returns the union of rows that belong to the current and the history table.

[ExpressionMethod("SqlServer", "TemporalTableAllImpl")]
public static ISqlServerSpecificTable<TSource> TemporalTableAll<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Table-like query source with FOR SYSTEM_TIME ALL filter.

Type Parameters

TSource

TemporalTableAsOf<TSource>(ISqlServerSpecificTable<TSource>, DateTime)

See Temporal table

Expression
AS OF dateTime
Qualifying Rows
ValidFrom <= dateTime AND ValidTo > dateTime
Note
Returns a table with rows containing the values that were current at the specified point in time in the past. Internally, a union is performed between the temporal table and its history table and the results are filtered to return the values in the row that was valid at the point in time specified by the dateTime parameter. The value for a row is deemed valid if the system_start_time_column_name value is less than or equal to the dateTime parameter value and the system_end_time_column_name value is greater than the dateTime parameter value.

[ExpressionMethod("SqlServer", "TemporalTableAsOfImpl")]
public static ISqlServerSpecificTable<TSource> TemporalTableAsOf<TSource>(this ISqlServerSpecificTable<TSource> table, DateTime dateTime) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

dateTime DateTime

Returns

ISqlServerSpecificTable<TSource>

Table-like query source with FOR SYSTEM_TIME AS OFdateTime filter.

Type Parameters

TSource

TemporalTableBetween<TSource>(ISqlServerSpecificTable<TSource>, DateTime, DateTime)

See Temporal table

Expression
BETWEEN dateTime AND dateTime2
Qualifying Rows
ValidFrom <= dateTime2 AND ValidTo > dateTime
Note
Same as in the FOR SYSTEM_TIME FROMdateTimeTOdateTime2 description, except the table of rows returned includes rows that became active on the upper boundary defined by the dateTime2 endpoint.

[ExpressionMethod("SqlServer", "TemporalTableBetweenImpl")]
public static ISqlServerSpecificTable<TSource> TemporalTableBetween<TSource>(this ISqlServerSpecificTable<TSource> table, DateTime dateTime, DateTime dateTime2) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

dateTime DateTime

dateTime2 DateTime

Returns

ISqlServerSpecificTable<TSource>

Table-like query source with FOR SYSTEM_TIME BETWEENdateTimeANDdateTime2 filter.

Type Parameters

TSource

TemporalTableContainedIn<TSource>(ISqlServerSpecificTable<TSource>, DateTime, DateTime)

See Temporal table

Expression
CONTAINED IN (dateTime, dateTime2)
Qualifying Rows
ValidFrom >= dateTime AND ValidTo <= dateTime2
Note
Returns a table with the values for all row versions that were opened and closed within the specified time range defined by the two period values for the CONTAINED IN argument. Rows that became active exactly on the lower boundary or ceased being active exactly on the upper boundary are included.

[ExpressionMethod("SqlServer", "TemporalTableContainedInImpl")]
public static ISqlServerSpecificTable<TSource> TemporalTableContainedIn<TSource>(this ISqlServerSpecificTable<TSource> table, DateTime dateTime, DateTime dateTime2) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

dateTime DateTime

dateTime2 DateTime

Returns

ISqlServerSpecificTable<TSource>

Table-like query source with FOR SYSTEM_TIME CONTAINED IN (dateTime, dateTime2) filter.

Type Parameters

TSource

TemporalTableFromTo<TSource>(ISqlServerSpecificTable<TSource>, DateTime, DateTime)

See Temporal table

Expression
FROM dateTime TO dateTime2
Qualifying Rows
ValidFrom < dateTime2 AND ValidTo > dateTime
Note
Returns a table with the values for all row versions that were active within the specified time range, regardless of whether they started being active before the dateTime parameter value for the FROM argument or ceased being active after the dateTime2 parameter value for the TO argument. Internally, a union is performed between the temporal table and its history table and the results are filtered to return the values for all row versions that were active at any time during the time range specified. Rows that stopped being active exactly on the lower boundary defined by the FROM endpoint aren't included, and records that became active exactly on the upper boundary defined by the TO endpoint are also not included.

[ExpressionMethod("SqlServer", "TemporalTableFromToImpl")]
public static ISqlServerSpecificTable<TSource> TemporalTableFromTo<TSource>(this ISqlServerSpecificTable<TSource> table, DateTime dateTime, DateTime dateTime2) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

dateTime DateTime

dateTime2 DateTime

Returns

ISqlServerSpecificTable<TSource>

Table-like query source with FOR SYSTEM_TIME FROMdateTimeTOdateTime2 filter.

Type Parameters

TSource

WithForceScanInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithForceScanQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithForceScanInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithForceScan<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithForceScanTableImpl")]
public static ISqlServerSpecificTable<TSource> WithForceScan<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithForceSeekInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithForceSeekQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithForceSeekInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithForceSeek<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithForceSeekTableImpl")]
public static ISqlServerSpecificTable<TSource> WithForceSeek<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithForceSeek<TSource>(ISqlServerSpecificTable<TSource>, string, params Expression<Func<TSource, object>>[])

[Sql.QueryExtension("SqlServer", Sql.QueryExtensionScope.TableHint, typeof(SqlServerHints.WithForceSeekExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static ISqlServerSpecificTable<TSource> WithForceSeek<TSource>(this ISqlServerSpecificTable<TSource> table, string indexName, params Expression<Func<TSource, object>>[] columns) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

indexName string

columns Expression<Func<TSource, object>>[]

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithHoldLockInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithHoldLockQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithHoldLockInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithHoldLock<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithHoldLockTableImpl")]
public static ISqlServerSpecificTable<TSource> WithHoldLock<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithIndex<TSource>(ISqlServerSpecificTable<TSource>, string)

[ExpressionMethod("WithIndexImpl")]
public static ISqlServerSpecificTable<TSource> WithIndex<TSource>(this ISqlServerSpecificTable<TSource> table, string indexName) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

indexName string

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithIndex<TSource>(ISqlServerSpecificTable<TSource>, params string[])

[ExpressionMethod("WithIndex2Impl")]
public static ISqlServerSpecificTable<TSource> WithIndex<TSource>(this ISqlServerSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

indexNames string[]

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithNoLockInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithNoLockQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithNoLockInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithNoLock<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithNoLockTableImpl")]
public static ISqlServerSpecificTable<TSource> WithNoLock<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithNoWaitInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithNoWaitQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithNoWaitInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithNoWait<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithNoWaitTableImpl")]
public static ISqlServerSpecificTable<TSource> WithNoWait<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithPagLockInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithPagLockQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithPagLockInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithPagLock<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithPagLockTableImpl")]
public static ISqlServerSpecificTable<TSource> WithPagLock<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithReadCommittedInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithReadCommittedQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithReadCommittedInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithReadCommittedLockInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithReadCommittedLockQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithReadCommittedLockInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithReadCommittedLock<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithReadCommittedLockTableImpl")]
public static ISqlServerSpecificTable<TSource> WithReadCommittedLock<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithReadCommitted<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithReadCommittedTableImpl")]
public static ISqlServerSpecificTable<TSource> WithReadCommitted<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithReadPastInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithReadPastQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithReadPastInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithReadPast<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithReadPastTableImpl")]
public static ISqlServerSpecificTable<TSource> WithReadPast<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithReadUncommittedInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithReadUncommittedQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithReadUncommittedInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithReadUncommitted<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithReadUncommittedTableImpl")]
public static ISqlServerSpecificTable<TSource> WithReadUncommitted<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithRepeatableReadInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithRepeatableReadQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithRepeatableReadInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithRepeatableRead<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithRepeatableReadTableImpl")]
public static ISqlServerSpecificTable<TSource> WithRepeatableRead<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithRowLockInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithRowLockQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithRowLockInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithRowLock<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithRowLockTableImpl")]
public static ISqlServerSpecificTable<TSource> WithRowLock<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithSerializableInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithSerializableQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithSerializableInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithSerializable<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithSerializableTableImpl")]
public static ISqlServerSpecificTable<TSource> WithSerializable<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithSnapshotInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithSnapshotQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithSnapshotInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithSnapshot<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithSnapshotTableImpl")]
public static ISqlServerSpecificTable<TSource> WithSnapshot<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithSpatialWindowMaxCells<TSource>(ISqlServerSpecificTable<TSource>, int)

[ExpressionMethod("WithSpatialWindowMaxCellsImpl")]
public static ISqlServerSpecificTable<TSource> WithSpatialWindowMaxCells<TSource>(this ISqlServerSpecificTable<TSource> table, int cells) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

cells int

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithTabLockInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithTabLockQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithTabLockInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithTabLockXInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithTabLockXQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithTabLockXInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithTabLockX<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithTabLockXTableImpl")]
public static ISqlServerSpecificTable<TSource> WithTabLockX<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithTabLock<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithTabLockTableImpl")]
public static ISqlServerSpecificTable<TSource> WithTabLock<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithUpdLockInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithUpdLockQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithUpdLockInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithUpdLock<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithUpdLockTableImpl")]
public static ISqlServerSpecificTable<TSource> WithUpdLock<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource

WithXLockInScope<TSource>(ISqlServerSpecificQueryable<TSource>)

[ExpressionMethod("SqlServer", "WithXLockQueryImpl")]
public static ISqlServerSpecificQueryable<TSource> WithXLockInScope<TSource>(this ISqlServerSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query ISqlServerSpecificQueryable<TSource>

Returns

ISqlServerSpecificQueryable<TSource>

Type Parameters

TSource

WithXLock<TSource>(ISqlServerSpecificTable<TSource>)

[ExpressionMethod("SqlServer", "WithXLockTableImpl")]
public static ISqlServerSpecificTable<TSource> WithXLock<TSource>(this ISqlServerSpecificTable<TSource> table) where TSource : notnull

Parameters

table ISqlServerSpecificTable<TSource>

Returns

ISqlServerSpecificTable<TSource>

Type Parameters

TSource