Class OracleHints

Namespace

LinqToDB.DataProvider.Oracle

Assembly

linq2db.dll

public static class OracleHints

Inheritance

object

OracleHints

Methods

AllRowsHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("AllRowsHintImpl")]
public static IOracleSpecificQueryable<TSource> AllRowsHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

AppendHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("AppendHintImpl")]
public static IOracleSpecificQueryable<TSource> AppendHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

AppendValuesHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("AppendValuesHintImpl")]
public static IOracleSpecificQueryable<TSource> AppendValuesHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

CacheHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "CacheTableHintImpl")]
public static IOracleSpecificTable<TSource> CacheHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

CacheInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "CacheInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> CacheInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

ClusterHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "ClusterTableHintImpl")]
public static IOracleSpecificTable<TSource> ClusterHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

ClusterInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "ClusterInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> ClusterInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

ClusteringHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("ClusteringHintImpl")]
public static IOracleSpecificQueryable<TSource> ClusteringHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

ContainersHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("ContainersHintImpl")]
public static IOracleSpecificQueryable<TSource> ContainersHint<TSource>(this IOracleSpecificQueryable<TSource> query, string hint) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

hint string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

CursorSharingExactHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("CursorSharingExactHintImpl")]
public static IOracleSpecificQueryable<TSource> CursorSharingExactHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

DisableParallelDmlHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("DisableParallelDmlHintImpl")]
public static IOracleSpecificQueryable<TSource> DisableParallelDmlHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

DrivingSiteHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "DrivingSiteTableHintImpl")]
public static IOracleSpecificTable<TSource> DrivingSiteHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

DrivingSiteInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "DrivingSiteInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> DrivingSiteInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

DynamicSamplingHint<TSource>(IOracleSpecificTable<TSource>, int)

[ExpressionMethod("DynamicSamplingHintImpl")]
public static IOracleSpecificTable<TSource> DynamicSamplingHint<TSource>(this IOracleSpecificTable<TSource> table, int value) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

value int

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

EnableParallelDmlHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("EnableParallelDmlHintImpl")]
public static IOracleSpecificQueryable<TSource> EnableParallelDmlHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

FactHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "FactTableHintImpl")]
public static IOracleSpecificTable<TSource> FactHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

FactInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "FactInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> FactInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

FirstRowsHint<TSource>(IOracleSpecificQueryable<TSource>, int)

[ExpressionMethod("FirstRowsHintImpl2")]
public static IOracleSpecificQueryable<TSource> FirstRowsHint<TSource>(this IOracleSpecificQueryable<TSource> query, int value) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

value int

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

FreshMVHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("FreshMVHintImpl")]
public static IOracleSpecificQueryable<TSource> FreshMVHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

FreshMaterializedViewHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("FreshMaterializedViewHintImpl")]
public static IOracleSpecificQueryable<TSource> FreshMaterializedViewHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

FullHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "FullTableHintImpl")]
public static IOracleSpecificTable<TSource> FullHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

FullInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "FullInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> FullInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

GroupingHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("GroupingHintImpl")]
public static IOracleSpecificQueryable<TSource> GroupingHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

HashHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "HashTableHintImpl")]
public static IOracleSpecificTable<TSource> HashHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

HashInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "HashInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> HashInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

InMemoryHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "InMemoryTableHintImpl")]
public static IOracleSpecificTable<TSource> InMemoryHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

InMemoryInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "InMemoryInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> InMemoryInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

InMemoryPruningHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "InMemoryPruningTableHintImpl")]
public static IOracleSpecificTable<TSource> InMemoryPruningHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

InMemoryPruningInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "InMemoryPruningInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> InMemoryPruningInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

IndexAscHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexAscIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexAscHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexCombineHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexCombineIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexCombineHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexDescHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexDescIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexDescHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexFFSHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexFFSIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexFFSHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexFastFullScanHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexFastFullScanIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexFastFullScanHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexJoinHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexJoinIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexJoinHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexSSAscHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexSSAscIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexSSAscHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexSSDescHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexSSDescIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexSSDescHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexSSHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexSSIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexSSHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexSkipScanAscHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexSkipScanAscIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexSkipScanAscHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexSkipScanDescHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexSkipScanDescIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexSkipScanDescHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

IndexSkipScanHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "IndexSkipScanIndexHintImpl")]
public static IOracleSpecificTable<TSource> IndexSkipScanHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

LeadingHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("LeadingHintImpl4")]
public static IOracleSpecificQueryable<TSource> LeadingHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

MergeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("MergeHintImpl")]
public static IOracleSpecificQueryable<TSource> MergeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

MergeHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("MergeHintImpl3")]
public static IOracleSpecificQueryable<TSource> MergeHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

MergeHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "MergeTableHintImpl")]
public static IOracleSpecificTable<TSource> MergeHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

MergeInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "MergeInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> MergeInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

ModelMinAnalysisHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("ModelMinAnalysisHintImpl")]
public static IOracleSpecificQueryable<TSource> ModelMinAnalysisHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

MonitorHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("MonitorHintImpl")]
public static IOracleSpecificQueryable<TSource> MonitorHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NativeFullOuterJoinHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NativeFullOuterJoinHintImpl")]
public static IOracleSpecificQueryable<TSource> NativeFullOuterJoinHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoAppendHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoAppendHintImpl")]
public static IOracleSpecificQueryable<TSource> NoAppendHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoCacheHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "NoCacheTableHintImpl")]
public static IOracleSpecificTable<TSource> NoCacheHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoCacheInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "NoCacheInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> NoCacheInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoClusteringHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoClusteringHintImpl")]
public static IOracleSpecificQueryable<TSource> NoClusteringHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoExpandHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoExpandHintImpl")]
public static IOracleSpecificQueryable<TSource> NoExpandHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoExpandHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("NoExpandHintImpl3")]
public static IOracleSpecificQueryable<TSource> NoExpandHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoFactHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "NoFactTableHintImpl")]
public static IOracleSpecificTable<TSource> NoFactHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoFactInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "NoFactInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> NoFactInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoInMemoryHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "NoInMemoryTableHintImpl")]
public static IOracleSpecificTable<TSource> NoInMemoryHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoInMemoryInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "NoInMemoryInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> NoInMemoryInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoInMemoryPruningHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "NoInMemoryPruningTableHintImpl")]
public static IOracleSpecificTable<TSource> NoInMemoryPruningHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoInMemoryPruningInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "NoInMemoryPruningInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> NoInMemoryPruningInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoIndexFFSHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "NoIndexFFSIndexHintImpl")]
public static IOracleSpecificTable<TSource> NoIndexFFSHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoIndexFastFullScanHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "NoIndexFastFullScanIndexHintImpl")]
public static IOracleSpecificTable<TSource> NoIndexFastFullScanHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoIndexHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "NoIndexIndexHintImpl")]
public static IOracleSpecificTable<TSource> NoIndexHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoIndexSSHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "NoIndexSSIndexHintImpl")]
public static IOracleSpecificTable<TSource> NoIndexSSHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoIndexSkipScanHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "NoIndexSkipScanIndexHintImpl")]
public static IOracleSpecificTable<TSource> NoIndexSkipScanHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoMergeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoMergeHintImpl")]
public static IOracleSpecificQueryable<TSource> NoMergeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoMergeHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("NoMergeHintImpl3")]
public static IOracleSpecificQueryable<TSource> NoMergeHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoMergeHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "NoMergeTableHintImpl")]
public static IOracleSpecificTable<TSource> NoMergeHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoMergeInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "NoMergeInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> NoMergeInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoMonitorHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoMonitorHintImpl")]
public static IOracleSpecificQueryable<TSource> NoMonitorHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoNativeFullOuterJoinHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoNativeFullOuterJoinHintImpl")]
public static IOracleSpecificQueryable<TSource> NoNativeFullOuterJoinHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoPQConcurrentUnionHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoPQConcurrentUnionHintImpl")]
public static IOracleSpecificQueryable<TSource> NoPQConcurrentUnionHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoPQConcurrentUnionHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("NoPQConcurrentUnionHintImpl3")]
public static IOracleSpecificQueryable<TSource> NoPQConcurrentUnionHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoPQSkewHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "NoPQSkewTableHintImpl")]
public static IOracleSpecificTable<TSource> NoPQSkewHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoPQSkewInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "NoPQSkewInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> NoPQSkewInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoParallelHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "NoParallelTableHintImpl")]
public static IOracleSpecificTable<TSource> NoParallelHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoParallelInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "NoParallelInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> NoParallelInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoParallelIndexHint<TSource>(IOracleSpecificTable<TSource>, params object[])

[ExpressionMethod("NoParallelIndexHintImpl")]
public static IOracleSpecificTable<TSource> NoParallelIndexHint<TSource>(this IOracleSpecificTable<TSource> table, params object[] values) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

values object[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoPushPredicateHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoPushPredicateHintImpl")]
public static IOracleSpecificQueryable<TSource> NoPushPredicateHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoPushPredicateHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("NoPushPredicateHintImpl3")]
public static IOracleSpecificQueryable<TSource> NoPushPredicateHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoPushPredicateHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "NoPushPredicateTableHintImpl")]
public static IOracleSpecificTable<TSource> NoPushPredicateHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoPushPredicateInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "NoPushPredicateInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> NoPushPredicateInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoPushSubQueriesHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("NoPushSubQueriesHintImpl3")]
public static IOracleSpecificQueryable<TSource> NoPushSubQueriesHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoPxJoinFilterHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "NoPxJoinFilterTableHintImpl")]
public static IOracleSpecificTable<TSource> NoPxJoinFilterHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

NoPxJoinFilterInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "NoPxJoinFilterInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> NoPxJoinFilterInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoQueryTransformationHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoQueryTransformationHintImpl")]
public static IOracleSpecificQueryable<TSource> NoQueryTransformationHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoRewriteHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoRewriteHintImpl")]
public static IOracleSpecificQueryable<TSource> NoRewriteHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoRewriteHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("NoRewriteHintImpl3")]
public static IOracleSpecificQueryable<TSource> NoRewriteHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoStarTransformationHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoStarTransformationHintImpl")]
public static IOracleSpecificQueryable<TSource> NoStarTransformationHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoStarTransformationHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("NoStarTransformationHintImpl3")]
public static IOracleSpecificQueryable<TSource> NoStarTransformationHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoUnnestHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoUnnestHintImpl")]
public static IOracleSpecificQueryable<TSource> NoUnnestHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoUnnestHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("NoUnnestHintImpl3")]
public static IOracleSpecificQueryable<TSource> NoUnnestHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoUseBandHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoUseBandHintImpl4")]
public static IOracleSpecificQueryable<TSource> NoUseBandHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoUseCubeHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoUseCubeHintImpl4")]
public static IOracleSpecificQueryable<TSource> NoUseCubeHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoUseHashHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoUseHashHintImpl4")]
public static IOracleSpecificQueryable<TSource> NoUseHashHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoUseMergeHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoUseMergeHintImpl4")]
public static IOracleSpecificQueryable<TSource> NoUseMergeHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoUseNLHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoUseNLHintImpl4")]
public static IOracleSpecificQueryable<TSource> NoUseNLHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoUseNestedLoopHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoUseNestedLoopHintImpl4")]
public static IOracleSpecificQueryable<TSource> NoUseNestedLoopHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoXmlIndexRewriteHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoXmlIndexRewriteHintImpl")]
public static IOracleSpecificQueryable<TSource> NoXmlIndexRewriteHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

NoXmlQueryRewriteHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("NoXmlQueryRewriteHintImpl")]
public static IOracleSpecificQueryable<TSource> NoXmlQueryRewriteHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

OptParamHint<TSource>(IOracleSpecificQueryable<TSource>, params string[])

[ExpressionMethod("OptParamHintImpl")]
public static IOracleSpecificQueryable<TSource> OptParamHint<TSource>(this IOracleSpecificQueryable<TSource> query, params string[] parameters) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

parameters string[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

OrderedHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("OrderedHintImpl")]
public static IOracleSpecificQueryable<TSource> OrderedHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PQConcurrentUnionHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("PQConcurrentUnionHintImpl")]
public static IOracleSpecificQueryable<TSource> PQConcurrentUnionHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PQConcurrentUnionHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("PQConcurrentUnionHintImpl3")]
public static IOracleSpecificQueryable<TSource> PQConcurrentUnionHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PQDistributeHint<TSource>(IOracleSpecificTable<TSource>, string, string)

[ExpressionMethod("PQDistributeHintImpl")]
public static IOracleSpecificTable<TSource> PQDistributeHint<TSource>(this IOracleSpecificTable<TSource> table, string outerDistribution, string innerDistribution) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

outerDistribution string

innerDistribution string

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

PQFilterHashHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("PQFilterHashHintImpl")]
public static IOracleSpecificQueryable<TSource> PQFilterHashHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PQFilterNoneHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("PQFilterNoneHintImpl")]
public static IOracleSpecificQueryable<TSource> PQFilterNoneHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PQFilterRandomHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("PQFilterRandomHintImpl")]
public static IOracleSpecificQueryable<TSource> PQFilterRandomHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PQFilterSerialHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("PQFilterSerialHintImpl")]
public static IOracleSpecificQueryable<TSource> PQFilterSerialHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PQSkewHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "PQSkewTableHintImpl")]
public static IOracleSpecificTable<TSource> PQSkewHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

PQSkewInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "PQSkewInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> PQSkewInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

ParallelAutoHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("ParallelAutoHintImpl")]
public static IOracleSpecificQueryable<TSource> ParallelAutoHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

ParallelDefaultHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("ParallelDefaultHintImpl")]
public static IOracleSpecificQueryable<TSource> ParallelDefaultHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

ParallelDefaultHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("ParallelDefaultHintImpl3")]
public static IOracleSpecificTable<TSource> ParallelDefaultHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

ParallelHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("ParallelHintImpl")]
public static IOracleSpecificQueryable<TSource> ParallelHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

ParallelHint<TSource>(IOracleSpecificQueryable<TSource>, int)

[ExpressionMethod("ParallelHintImpl2")]
public static IOracleSpecificQueryable<TSource> ParallelHint<TSource>(this IOracleSpecificQueryable<TSource> query, int value) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

value int

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

ParallelHint<TSource>(IOracleSpecificTable<TSource>, int)

[ExpressionMethod("ParallelHintImpl3")]
public static IOracleSpecificTable<TSource> ParallelHint<TSource>(this IOracleSpecificTable<TSource> table, int value) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

value int

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

ParallelIndexHint<TSource>(IOracleSpecificTable<TSource>, params object[])

[ExpressionMethod("ParallelIndexHintImpl")]
public static IOracleSpecificTable<TSource> ParallelIndexHint<TSource>(this IOracleSpecificTable<TSource> table, params object[] values) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

values object[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

ParallelManualHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("ParallelManualHintImpl")]
public static IOracleSpecificQueryable<TSource> ParallelManualHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PushPredicateHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("PushPredicateHintImpl")]
public static IOracleSpecificQueryable<TSource> PushPredicateHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PushPredicateHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("PushPredicateHintImpl3")]
public static IOracleSpecificQueryable<TSource> PushPredicateHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PushPredicateHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "PushPredicateTableHintImpl")]
public static IOracleSpecificTable<TSource> PushPredicateHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

PushPredicateInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "PushPredicateInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> PushPredicateInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PushSubQueriesHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("PushSubQueriesHintImpl3")]
public static IOracleSpecificQueryable<TSource> PushSubQueriesHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

PxJoinFilterHint<TSource>(IOracleSpecificTable<TSource>)

[ExpressionMethod("Oracle", "PxJoinFilterTableHintImpl")]
public static IOracleSpecificTable<TSource> PxJoinFilterHint<TSource>(this IOracleSpecificTable<TSource> table) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

PxJoinFilterInScopeHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("Oracle", "PxJoinFilterInScopeHintImpl")]
public static IOracleSpecificQueryable<TSource> PxJoinFilterInScopeHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

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

Adds a query hint to a generated query.

// will produce following SQL code in generated query: INNER LOOP JOIN
var tableWithHint = db.Table.JoinHint("LOOP");

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

Parameters

source IOracleSpecificQueryable<TSource>

Query source.

hint string

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

Returns

IOracleSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

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

Adds a query hint to the generated query.

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

Parameters

source IOracleSpecificQueryable<TSource>

Query source.

hint string

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

hintParameter TParam

Hint parameter.

Returns

IOracleSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TParam

Hint parameter type

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

Adds a query hint to the generated query.

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

Parameters

source IOracleSpecificQueryable<TSource>

Query source.

hint string

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

hintParameters TParam[]

Table hint parameters.

Returns

IOracleSpecificQueryable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

RewriteHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("RewriteHintImpl")]
public static IOracleSpecificQueryable<TSource> RewriteHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

RewriteHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("RewriteHintImpl3")]
public static IOracleSpecificQueryable<TSource> RewriteHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

StarTransformationHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("StarTransformationHintImpl")]
public static IOracleSpecificQueryable<TSource> StarTransformationHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

StarTransformationHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("StarTransformationHintImpl3")]
public static IOracleSpecificQueryable<TSource> StarTransformationHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

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

Adds a table hint to a table in generated query.

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

Parameters

table IOracleSpecificTable<TSource>

Table-like query source.

hint string

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

Returns

IOracleSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

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

Adds a table hint to a table in generated query.

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

Parameters

table IOracleSpecificTable<TSource>

Table-like query source.

hint string

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

hintParameter TParam

Table hint parameter.

Returns

IOracleSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

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

Adds a table hint to a table in generated query.

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

Parameters

table IOracleSpecificTable<TSource>

Table-like query source.

hint string

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

hintParameters TParam[]

Table hint parameters.

Returns

IOracleSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

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

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

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

Parameters

source IOracleSpecificQueryable<TSource>

Query source.

hint string

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

Returns

IOracleSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

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

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

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

Parameters

source IOracleSpecificQueryable<TSource>

Query source.

hint string

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

hintParameters object[]

Table hint parameters.

Returns

IOracleSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

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

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

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

Parameters

source IOracleSpecificQueryable<TSource>

Query source.

hint string

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

hintParameter TParam

Table hint parameter.

Returns

IOracleSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

UnnestHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("UnnestHintImpl")]
public static IOracleSpecificQueryable<TSource> UnnestHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

UnnestHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("UnnestHintImpl3")]
public static IOracleSpecificQueryable<TSource> UnnestHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

UseBandHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("UseBandHintImpl4")]
public static IOracleSpecificQueryable<TSource> UseBandHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

UseConcatHint<TSource>(IOracleSpecificQueryable<TSource>)

[ExpressionMethod("UseConcatHintImpl")]
public static IOracleSpecificQueryable<TSource> UseConcatHint<TSource>(this IOracleSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

UseConcatHint<TSource>(IOracleSpecificQueryable<TSource>, string)

[ExpressionMethod("UseConcatHintImpl3")]
public static IOracleSpecificQueryable<TSource> UseConcatHint<TSource>(this IOracleSpecificQueryable<TSource> query, string queryBlock) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

queryBlock string

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

UseCubeHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("UseCubeHintImpl4")]
public static IOracleSpecificQueryable<TSource> UseCubeHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

UseHashHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("UseHashHintImpl4")]
public static IOracleSpecificQueryable<TSource> UseHashHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

UseMergeHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("UseMergeHintImpl4")]
public static IOracleSpecificQueryable<TSource> UseMergeHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

UseNLHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("UseNLHintImpl4")]
public static IOracleSpecificQueryable<TSource> UseNLHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

UseNLWithIndexHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "UseNLWithIndexIndexHintImpl")]
public static IOracleSpecificTable<TSource> UseNLWithIndexHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource

UseNestedLoopHint<TSource>(IOracleSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("UseNestedLoopHintImpl4")]
public static IOracleSpecificQueryable<TSource> UseNestedLoopHint<TSource>(this IOracleSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IOracleSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IOracleSpecificQueryable<TSource>

Type Parameters

TSource

UseNestedLoopWithIndexHint<TSource>(IOracleSpecificTable<TSource>, params string[])

[ExpressionMethod("Oracle", "UseNestedLoopWithIndexIndexHintImpl")]
public static IOracleSpecificTable<TSource> UseNestedLoopWithIndexHint<TSource>(this IOracleSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IOracleSpecificTable<TSource>

indexNames string[]

Returns

IOracleSpecificTable<TSource>

Type Parameters

TSource