Class MySqlHints

Namespace

LinqToDB.DataProvider.MySql

Assembly

linq2db.dll

public static class MySqlHints

Inheritance

object

MySqlHints

Methods

BatchedKeyAccessHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("BatchedKeyAccessHintImpl4")]
public static IMySqlSpecificQueryable<TSource> BatchedKeyAccessHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

BatchedKeyAccessHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "BatchedKeyAccessTableHintImpl")]
public static IMySqlSpecificTable<TSource> BatchedKeyAccessHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

BatchedKeyAccessInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "BatchedKeyAccessInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> BatchedKeyAccessInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

BkaHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("BkaHintImpl4")]
public static IMySqlSpecificQueryable<TSource> BkaHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

BkaHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "BkaTableHintImpl")]
public static IMySqlSpecificTable<TSource> BkaHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

BkaInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "BkaInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> BkaInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

BlockNestedLoopHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("BlockNestedLoopHintImpl4")]
public static IMySqlSpecificQueryable<TSource> BlockNestedLoopHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

BlockNestedLoopHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "BlockNestedLoopTableHintImpl")]
public static IMySqlSpecificTable<TSource> BlockNestedLoopHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

BlockNestedLoopInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "BlockNestedLoopInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> BlockNestedLoopInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

BnlHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("BnlHintImpl4")]
public static IMySqlSpecificQueryable<TSource> BnlHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

BnlHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "BnlTableHintImpl")]
public static IMySqlSpecificTable<TSource> BnlHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

BnlInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "BnlInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> BnlInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

DerivedConditionPushDownHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("DerivedConditionPushDownHintImpl4")]
public static IMySqlSpecificQueryable<TSource> DerivedConditionPushDownHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

DerivedConditionPushDownHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "DerivedConditionPushDownTableHintImpl")]
public static IMySqlSpecificTable<TSource> DerivedConditionPushDownHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

DerivedConditionPushDownInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "DerivedConditionPushDownInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> DerivedConditionPushDownInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

ForShareHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("ForShareHintImpl")]
public static IMySqlSpecificQueryable<TSource> ForShareHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

ForShareNoWaitHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("ForShareNoWaitHintImpl")]
public static IMySqlSpecificQueryable<TSource> ForShareNoWaitHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

ForShareSkipLockedHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("ForShareSkipLockedHintImpl")]
public static IMySqlSpecificQueryable<TSource> ForShareSkipLockedHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

ForUpdateHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("ForUpdateHintImpl")]
public static IMySqlSpecificQueryable<TSource> ForUpdateHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

ForUpdateNoWaitHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("ForUpdateNoWaitHintImpl")]
public static IMySqlSpecificQueryable<TSource> ForUpdateNoWaitHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

ForUpdateSkipLockedHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("ForUpdateSkipLockedHintImpl")]
public static IMySqlSpecificQueryable<TSource> ForUpdateSkipLockedHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

ForceIndexForGroupByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "ForceIndexForGroupByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> ForceIndexForGroupByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

ForceIndexForJoinHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "ForceIndexForJoinIndexHintImpl")]
public static IMySqlSpecificTable<TSource> ForceIndexForJoinHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

ForceIndexForOrderByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "ForceIndexForOrderByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> ForceIndexForOrderByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

ForceIndexHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "ForceIndexIndexHintImpl")]
public static IMySqlSpecificTable<TSource> ForceIndexHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

ForceKeyForGroupByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "ForceKeyForGroupByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> ForceKeyForGroupByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

ForceKeyForJoinHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "ForceKeyForJoinIndexHintImpl")]
public static IMySqlSpecificTable<TSource> ForceKeyForJoinHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

ForceKeyForOrderByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "ForceKeyForOrderByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> ForceKeyForOrderByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

ForceKeyHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "ForceKeyIndexHintImpl")]
public static IMySqlSpecificTable<TSource> ForceKeyHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

GroupIndexHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "GroupIndexIndexHintImpl")]
public static IMySqlSpecificTable<TSource> GroupIndexHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

HashJoinHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("HashJoinHintImpl4")]
public static IMySqlSpecificQueryable<TSource> HashJoinHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

HashJoinHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "HashJoinTableHintImpl")]
public static IMySqlSpecificTable<TSource> HashJoinHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

HashJoinInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "HashJoinInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> HashJoinInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

IgnoreIndexForGroupByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "IgnoreIndexForGroupByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> IgnoreIndexForGroupByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

IgnoreIndexForJoinHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "IgnoreIndexForJoinIndexHintImpl")]
public static IMySqlSpecificTable<TSource> IgnoreIndexForJoinHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

IgnoreIndexForOrderByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "IgnoreIndexForOrderByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> IgnoreIndexForOrderByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

IgnoreIndexHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "IgnoreIndexIndexHintImpl")]
public static IMySqlSpecificTable<TSource> IgnoreIndexHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

IgnoreKeyForGroupByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "IgnoreKeyForGroupByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> IgnoreKeyForGroupByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

IgnoreKeyForJoinHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "IgnoreKeyForJoinIndexHintImpl")]
public static IMySqlSpecificTable<TSource> IgnoreKeyForJoinHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

IgnoreKeyForOrderByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "IgnoreKeyForOrderByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> IgnoreKeyForOrderByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

IgnoreKeyHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "IgnoreKeyIndexHintImpl")]
public static IMySqlSpecificTable<TSource> IgnoreKeyHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

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

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

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

IndexMergeHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "IndexMergeIndexHintImpl")]
public static IMySqlSpecificTable<TSource> IndexMergeHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

JoinFixedOrderHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("JoinFixedOrderHintImpl4")]
public static IMySqlSpecificQueryable<TSource> JoinFixedOrderHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

JoinFixedOrderHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "JoinFixedOrderTableHintImpl")]
public static IMySqlSpecificTable<TSource> JoinFixedOrderHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

JoinFixedOrderInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "JoinFixedOrderInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> JoinFixedOrderInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

JoinIndexHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "JoinIndexIndexHintImpl")]
public static IMySqlSpecificTable<TSource> JoinIndexHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

JoinOrderHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("JoinOrderHintImpl4")]
public static IMySqlSpecificQueryable<TSource> JoinOrderHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

JoinOrderHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "JoinOrderTableHintImpl")]
public static IMySqlSpecificTable<TSource> JoinOrderHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

JoinOrderInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "JoinOrderInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> JoinOrderInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

JoinPrefixHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("JoinPrefixHintImpl4")]
public static IMySqlSpecificQueryable<TSource> JoinPrefixHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

JoinPrefixHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "JoinPrefixTableHintImpl")]
public static IMySqlSpecificTable<TSource> JoinPrefixHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

JoinPrefixInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "JoinPrefixInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> JoinPrefixInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

JoinSuffixHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("JoinSuffixHintImpl4")]
public static IMySqlSpecificQueryable<TSource> JoinSuffixHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

JoinSuffixHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "JoinSuffixTableHintImpl")]
public static IMySqlSpecificTable<TSource> JoinSuffixHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

JoinSuffixInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "JoinSuffixInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> JoinSuffixInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

LockInShareModeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("LockInShareModeHintImpl")]
public static IMySqlSpecificQueryable<TSource> LockInShareModeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

MaxExecutionTimeHint<TSource>(IMySqlSpecificQueryable<TSource>, int)

[ExpressionMethod("MaxExecutionTimeHintImpl2")]
public static IMySqlSpecificQueryable<TSource> MaxExecutionTimeHint<TSource>(this IMySqlSpecificQueryable<TSource> query, int value) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

value int

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

MergeHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("MergeHintImpl4")]
public static IMySqlSpecificQueryable<TSource> MergeHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

MergeHint<TSource>(IMySqlSpecificTable<TSource>)

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

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

MergeInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

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

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

MrrHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "MrrIndexHintImpl")]
public static IMySqlSpecificTable<TSource> MrrHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoBatchedKeyAccessHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoBatchedKeyAccessHintImpl4")]
public static IMySqlSpecificQueryable<TSource> NoBatchedKeyAccessHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoBatchedKeyAccessHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "NoBatchedKeyAccessTableHintImpl")]
public static IMySqlSpecificTable<TSource> NoBatchedKeyAccessHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoBatchedKeyAccessInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "NoBatchedKeyAccessInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> NoBatchedKeyAccessInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoBkaHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoBkaHintImpl4")]
public static IMySqlSpecificQueryable<TSource> NoBkaHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoBkaHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "NoBkaTableHintImpl")]
public static IMySqlSpecificTable<TSource> NoBkaHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoBkaInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "NoBkaInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> NoBkaInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoBlockNestedLoopHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoBlockNestedLoopHintImpl4")]
public static IMySqlSpecificQueryable<TSource> NoBlockNestedLoopHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoBlockNestedLoopHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "NoBlockNestedLoopTableHintImpl")]
public static IMySqlSpecificTable<TSource> NoBlockNestedLoopHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoBlockNestedLoopInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "NoBlockNestedLoopInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> NoBlockNestedLoopInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoBnlHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoBnlHintImpl4")]
public static IMySqlSpecificQueryable<TSource> NoBnlHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoBnlHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "NoBnlTableHintImpl")]
public static IMySqlSpecificTable<TSource> NoBnlHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoBnlInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "NoBnlInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> NoBnlInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoDerivedConditionPushDownHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoDerivedConditionPushDownHintImpl4")]
public static IMySqlSpecificQueryable<TSource> NoDerivedConditionPushDownHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoDerivedConditionPushDownHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "NoDerivedConditionPushDownTableHintImpl")]
public static IMySqlSpecificTable<TSource> NoDerivedConditionPushDownHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoDerivedConditionPushDownInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "NoDerivedConditionPushDownInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> NoDerivedConditionPushDownInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoGroupIndexHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "NoGroupIndexIndexHintImpl")]
public static IMySqlSpecificTable<TSource> NoGroupIndexHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoHashJoinHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoHashJoinHintImpl4")]
public static IMySqlSpecificQueryable<TSource> NoHashJoinHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoHashJoinHint<TSource>(IMySqlSpecificTable<TSource>)

[ExpressionMethod("MySql", "NoHashJoinTableHintImpl")]
public static IMySqlSpecificTable<TSource> NoHashJoinHint<TSource>(this IMySqlSpecificTable<TSource> table) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoHashJoinInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

[ExpressionMethod("MySql", "NoHashJoinInScopeHintImpl")]
public static IMySqlSpecificQueryable<TSource> NoHashJoinInScopeHint<TSource>(this IMySqlSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoIcpHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "NoIcpIndexHintImpl")]
public static IMySqlSpecificTable<TSource> NoIcpHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

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

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

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoIndexMergeHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "NoIndexMergeIndexHintImpl")]
public static IMySqlSpecificTable<TSource> NoIndexMergeHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoJoinIndexHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "NoJoinIndexIndexHintImpl")]
public static IMySqlSpecificTable<TSource> NoJoinIndexHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoMergeHint<TSource>(IMySqlSpecificQueryable<TSource>, params SqlID[])

[ExpressionMethod("NoMergeHintImpl4")]
public static IMySqlSpecificQueryable<TSource> NoMergeHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

tableIDs SqlID[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoMergeHint<TSource>(IMySqlSpecificTable<TSource>)

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

Parameters

table IMySqlSpecificTable<TSource>

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoMergeInScopeHint<TSource>(IMySqlSpecificQueryable<TSource>)

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

Parameters

query IMySqlSpecificQueryable<TSource>

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoMrrHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "NoMrrIndexHintImpl")]
public static IMySqlSpecificTable<TSource> NoMrrHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoOrderIndexHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "NoOrderIndexIndexHintImpl")]
public static IMySqlSpecificTable<TSource> NoOrderIndexHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoRangeOptimizationHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "NoRangeOptimizationIndexHintImpl")]
public static IMySqlSpecificTable<TSource> NoRangeOptimizationHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

NoSemiJoinHintWithQueryBlock<TSource>(IMySqlSpecificQueryable<TSource>, params string[])

[ExpressionMethod("NoSemiJoinHintWithQueryBlockImpl")]
public static IMySqlSpecificQueryable<TSource> NoSemiJoinHintWithQueryBlock<TSource>(this IMySqlSpecificQueryable<TSource> query, params string[] values) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

values string[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoSemiJoinHint<TSource>(IMySqlSpecificQueryable<TSource>, params string[])

[ExpressionMethod("NoSemiJoinHintImpl5")]
public static IMySqlSpecificQueryable<TSource> NoSemiJoinHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params string[] values) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

values string[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

NoSkipScanHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "NoSkipScanIndexHintImpl")]
public static IMySqlSpecificTable<TSource> NoSkipScanHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

OrderIndexHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "OrderIndexIndexHintImpl")]
public static IMySqlSpecificTable<TSource> OrderIndexHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

QueryBlockHint<TSource, TParam>(IMySqlSpecificQueryable<TSource>, string, params TParam[])

Adds a query hint to the generated query.

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

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

SQL text, added to join in generated query.

hintParameters TParam[]

Table hint parameters.

Returns

IMySqlSpecificQueryable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

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

Adds a query hint to a generated query.

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

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

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

Returns

IMySqlSpecificQueryable<TSource>

Query source with hints.

Type Parameters

TSource

Table record mapping class.

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

Adds a query hint to the generated query.

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

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

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

hintParameter TParam

Hint parameter.

Returns

IMySqlSpecificQueryable<TSource>

Query source with hints.

Type Parameters

TSource

Table record mapping class.

TParam

Hint parameter type

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

Adds a query hint to the generated query.

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

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

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

hintParameters TParam[]

Table hint parameters.

Returns

IMySqlSpecificQueryable<TSource>

Table-like query source with hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

ResourceGroupHint<TSource>(IMySqlSpecificQueryable<TSource>, string)

[ExpressionMethod("ResourceGroupHintImpl3")]
public static IMySqlSpecificQueryable<TSource> ResourceGroupHint<TSource>(this IMySqlSpecificQueryable<TSource> query, string value) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

value string

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

SemiJoinHintWithQueryBlock<TSource>(IMySqlSpecificQueryable<TSource>, params string[])

[ExpressionMethod("SemiJoinHintWithQueryBlockImpl")]
public static IMySqlSpecificQueryable<TSource> SemiJoinHintWithQueryBlock<TSource>(this IMySqlSpecificQueryable<TSource> query, params string[] values) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

values string[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

SemiJoinHint<TSource>(IMySqlSpecificQueryable<TSource>, params string[])

[ExpressionMethod("SemiJoinHintImpl5")]
public static IMySqlSpecificQueryable<TSource> SemiJoinHint<TSource>(this IMySqlSpecificQueryable<TSource> query, params string[] values) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

values string[]

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

SetVarHint<TSource>(IMySqlSpecificQueryable<TSource>, string)

[ExpressionMethod("SetVarHintImpl3")]
public static IMySqlSpecificQueryable<TSource> SetVarHint<TSource>(this IMySqlSpecificQueryable<TSource> query, string value) where TSource : notnull

Parameters

query IMySqlSpecificQueryable<TSource>

value string

Returns

IMySqlSpecificQueryable<TSource>

Type Parameters

TSource

SkipScanHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "SkipScanIndexHintImpl")]
public static IMySqlSpecificTable<TSource> SkipScanHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

SubQueryHint<TSource>(IMySqlSpecificQueryable<TSource>, string)

Adds a query hint to a generated query.

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

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

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

Returns

IMySqlSpecificQueryable<TSource>

Query source with hints.

Type Parameters

TSource

Table record mapping class.

SubQueryHint<TSource, TParam>(IMySqlSpecificQueryable<TSource>, string, TParam)

Adds a query hint to the generated query.

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

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

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

hintParameter TParam

Hint parameter.

Returns

IMySqlSpecificQueryable<TSource>

Query source with hints.

Type Parameters

TSource

Table record mapping class.

TParam

Hint parameter type

SubQueryHint<TSource, TParam>(IMySqlSpecificQueryable<TSource>, string, params TParam[])

Adds a query hint to the generated query.

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

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

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

hintParameters TParam[]

Table hint parameters.

Returns

IMySqlSpecificQueryable<TSource>

Table-like query source with hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

SubQueryTableHint<TSource>(IMySqlSpecificQueryable<TSource>, string, params SqlID[])

Adds subquery hint to a generated query.

[Sql.QueryExtension("MySql", Sql.QueryExtensionScope.SubQueryHint, typeof(MySqlHints.SubQueryTableHintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static IMySqlSpecificQueryable<TSource> SubQueryTableHint<TSource>(this IMySqlSpecificQueryable<TSource> source, string hint, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

SQL text, added to join in generated query.

tableIDs SqlID[]

Table IDs.

Returns

IMySqlSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

SubQueryTableHint<TSource>(IMySqlSpecificQueryable<TSource>, string, string, params SqlID[])

Adds subquery hint to a generated query.

[Sql.QueryExtension("MySql", Sql.QueryExtensionScope.SubQueryHint, typeof(MySqlHints.SubQueryTableHintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static IMySqlSpecificQueryable<TSource> SubQueryTableHint<TSource>(this IMySqlSpecificQueryable<TSource> source, string hint, string hint2, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

SQL text, added to join in generated query.

hint2 string

NOWAIT | SKIP LOCKED

tableIDs SqlID[]

Table IDs.

Returns

IMySqlSpecificQueryable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

SubQueryTableHint<TSource>(IMySqlSpecificTable<TSource>, string, params SqlID[])

Adds subquery hint to a generated query.

[Sql.QueryExtension("MySql", Sql.QueryExtensionScope.SubQueryHint, typeof(MySqlHints.SubQueryTableHintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static IMySqlSpecificTable<TSource> SubQueryTableHint<TSource>(this IMySqlSpecificTable<TSource> table, string hint, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Table-like query source.

hint string

SQL text, added to join in generated query.

tableIDs SqlID[]

Table IDs.

Returns

IMySqlSpecificTable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

SubQueryTableHint<TSource>(IMySqlSpecificTable<TSource>, string, string, params SqlID[])

Adds subquery hint to a generated query.

[Sql.QueryExtension("MySql", Sql.QueryExtensionScope.SubQueryHint, typeof(MySqlHints.SubQueryTableHintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static IMySqlSpecificTable<TSource> SubQueryTableHint<TSource>(this IMySqlSpecificTable<TSource> table, string hint, string hint2, params Sql.SqlID[] tableIDs) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Table-like query source.

hint string

SQL text, added to join in generated query.

hint2 string

NOWAIT | SKIP LOCKED

tableIDs SqlID[]

Table IDs.

Returns

IMySqlSpecificTable<TSource>

Query source with join hints.

Type Parameters

TSource

Table record mapping class.

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

Adds a table hint to a table in generated query.

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

Parameters

table IMySqlSpecificTable<TSource>

Table-like query source.

hint string

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

Returns

IMySqlSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

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

Adds a table hint to a table in generated query.

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

Parameters

table IMySqlSpecificTable<TSource>

Table-like query source.

hint string

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

hintParameter TParam

Table hint parameter.

Returns

IMySqlSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

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

Adds a table hint to a table in generated query.

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

Parameters

table IMySqlSpecificTable<TSource>

Table-like query source.

hint string

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

hintParameters TParam[]

Table hint parameters.

Returns

IMySqlSpecificTable<TSource>

Table-like query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

TableIndexHint<TSource>(IMySqlSpecificTable<TSource>, string)

Adds an index hint to a table in generated query.

[Sql.QueryExtension("MySql", Sql.QueryExtensionScope.IndexHint, typeof(HintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static IMySqlSpecificTable<TSource> TableIndexHint<TSource>(this IMySqlSpecificTable<TSource> table, string hint) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

Table-like query source.

hint string

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

Returns

IMySqlSpecificTable<TSource>

Table-like query source with index hints.

Type Parameters

TSource

Table record mapping class.

TableIndexHint<TSource, TParam>(IMySqlSpecificTable<TSource>, string, TParam)

Adds an index hint to a table in generated query.

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

Parameters

table IMySqlSpecificTable<TSource>

Table-like query source.

hint string

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

hintParameter TParam

Table hint parameter.

Returns

IMySqlSpecificTable<TSource>

Table-like query source with index hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

TableIndexHint<TSource, TParam>(IMySqlSpecificTable<TSource>, string, params TParam[])

Adds an index hint to a table in generated query.

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

Parameters

table IMySqlSpecificTable<TSource>

Table-like query source.

hint string

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

hintParameters TParam[]

Table hint parameters.

Returns

IMySqlSpecificTable<TSource>

Table-like query source with index hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

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

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

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

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

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

Returns

IMySqlSpecificQueryable<TSource>

Query source with table hints.

Type Parameters

TSource

Table record mapping class.

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

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

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

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

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

hintParameters object[]

Table hint parameters.

Returns

IMySqlSpecificQueryable<TSource>

Query source with table hints.

Type Parameters

TSource

Table record mapping class.

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

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

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

Parameters

source IMySqlSpecificQueryable<TSource>

Query source.

hint string

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

hintParameter TParam

Table hint parameter.

Returns

IMySqlSpecificQueryable<TSource>

Query source with table hints.

Type Parameters

TSource

Table record mapping class.

TParam

Table hint parameter type.

UseIndexForGroupByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "UseIndexForGroupByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> UseIndexForGroupByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

UseIndexForJoinHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "UseIndexForJoinIndexHintImpl")]
public static IMySqlSpecificTable<TSource> UseIndexForJoinHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

UseIndexForOrderByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "UseIndexForOrderByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> UseIndexForOrderByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

UseIndexHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "UseIndexIndexHintImpl")]
public static IMySqlSpecificTable<TSource> UseIndexHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

UseKeyForGroupByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "UseKeyForGroupByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> UseKeyForGroupByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

UseKeyForJoinHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "UseKeyForJoinIndexHintImpl")]
public static IMySqlSpecificTable<TSource> UseKeyForJoinHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

UseKeyForOrderByHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "UseKeyForOrderByIndexHintImpl")]
public static IMySqlSpecificTable<TSource> UseKeyForOrderByHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource

UseKeyHint<TSource>(IMySqlSpecificTable<TSource>, params string[])

[ExpressionMethod("MySql", "UseKeyIndexHintImpl")]
public static IMySqlSpecificTable<TSource> UseKeyHint<TSource>(this IMySqlSpecificTable<TSource> table, params string[] indexNames) where TSource : notnull

Parameters

table IMySqlSpecificTable<TSource>

indexNames string[]

Returns

IMySqlSpecificTable<TSource>

Type Parameters

TSource