Class ClickHouseHints

Namespace

LinqToDB.DataProvider.ClickHouse

Assembly

linq2db.dll

public static class ClickHouseHints

Inheritance

object

ClickHouseHints

Methods

FinalHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds FINAL modifier to FROM Clause.

[ExpressionMethod("ClickHouse", "FinalHintImpl")]
public static IClickHouseSpecificTable<TSource> FinalHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

FinalInScopeHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds FINAL modifier to FROM Clause of all the tables in the method scope.

[ExpressionMethod("ClickHouse", "FinalInScopeHintImpl")]
public static IClickHouseSpecificQueryable<TSource> FinalInScopeHint<TSource>(this IClickHouseSpecificQueryable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

FinalInScopeHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds FINAL modifier to FROM Clause.

[ExpressionMethod("ClickHouse", "FinalInScopeHintImpl2")]
public static IClickHouseSpecificTable<TSource> FinalInScopeHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinAllAntiHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds the same ClickHouse join hint as JoinAntiHint. This method is deprecated.

[Obsolete("TODO: remove in v7. This API is based on an incorrect ClickHouse join hint model and works incorrectly. Use JoinAntiHint instead.")]
[ExpressionMethod("JoinAllAntiHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinAllAntiHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinAllAntiHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds the same ClickHouse join hint as JoinAntiHint. This method is deprecated.

[Obsolete("TODO: remove in v7. This API is based on an incorrect ClickHouse join hint model and works incorrectly. Use JoinAntiHint instead.")]
[ExpressionMethod("JoinAllAntiTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinAllAntiHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinAllAnyHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds the same ClickHouse join hint as JoinAnyHint. This method is deprecated.

[Obsolete("TODO: remove in v7. This API is based on an incorrect ClickHouse join hint model and works incorrectly. Use JoinAnyHint instead.")]
[ExpressionMethod("JoinAllAnyHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinAllAnyHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinAllAnyHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds the same ClickHouse join hint as JoinAnyHint. This method is deprecated.

[Obsolete("TODO: remove in v7. This API is based on an incorrect ClickHouse join hint model and works incorrectly. Use JoinAnyHint instead.")]
[ExpressionMethod("JoinAllAnyTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinAllAnyHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinAllAsOfHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds the same ClickHouse join hint as JoinAsOfHint. This method is deprecated.

[Obsolete("TODO: remove in v7. This API is based on an incorrect ClickHouse join hint model and works incorrectly. Use JoinAsOfHint instead.")]
[ExpressionMethod("JoinAllAsOfHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinAllAsOfHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinAllAsOfHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds the same ClickHouse join hint as JoinAsOfHint. This method is deprecated.

[Obsolete("TODO: remove in v7. This API is based on an incorrect ClickHouse join hint model and works incorrectly. Use JoinAsOfHint instead.")]
[ExpressionMethod("JoinAllAsOfTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinAllAsOfHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinAllHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse ALL join hint.

[ExpressionMethod("JoinAllHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinAllHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinAllHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse ALL join hint.

[ExpressionMethod("JoinAllTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinAllHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinAllOuterHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds the same ClickHouse join hint as JoinOuterHint. This method is deprecated.

[Obsolete("TODO: remove in v7. This API is based on an incorrect ClickHouse join hint model and works incorrectly. Use JoinOuterHint instead.")]
[ExpressionMethod("JoinAllOuterHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinAllOuterHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinAllOuterHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds the same ClickHouse join hint as JoinOuterHint. This method is deprecated.

[Obsolete("TODO: remove in v7. This API is based on an incorrect ClickHouse join hint model and works incorrectly. Use JoinOuterHint instead.")]
[ExpressionMethod("JoinAllOuterTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinAllOuterHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinAllSemiHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds the same ClickHouse join hint as JoinSemiHint. This method is deprecated.

[Obsolete("TODO: remove in v7. This API is based on an incorrect ClickHouse join hint model and works incorrectly. Use JoinSemiHint instead.")]
[ExpressionMethod("JoinAllSemiHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinAllSemiHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinAllSemiHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds the same ClickHouse join hint as JoinSemiHint. This method is deprecated.

[Obsolete("TODO: remove in v7. This API is based on an incorrect ClickHouse join hint model and works incorrectly. Use JoinSemiHint instead.")]
[ExpressionMethod("JoinAllSemiTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinAllSemiHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinAntiHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse ANTI join hint.

[ExpressionMethod("JoinAntiHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinAntiHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinAntiHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse ANTI join hint.

[ExpressionMethod("JoinAntiTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinAntiHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinAnyHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse ANY join hint.

[ExpressionMethod("JoinAnyHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinAnyHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinAnyHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse ANY join hint.

[ExpressionMethod("JoinAnyTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinAnyHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinAsOfHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse ASOF join hint.

[ExpressionMethod("JoinAsOfHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinAsOfHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinAsOfHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse ASOF join hint.

[ExpressionMethod("JoinAsOfTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinAsOfHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinGlobalAllHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse GLOBAL ALL join hint.

[ExpressionMethod("JoinGlobalAllHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinGlobalAllHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinGlobalAllHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse GLOBAL ALL join hint.

[ExpressionMethod("JoinGlobalAllTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinGlobalAllHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinGlobalAntiHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse GLOBAL ANTI join hint.

[ExpressionMethod("JoinGlobalAntiHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinGlobalAntiHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinGlobalAntiHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse GLOBAL ANTI join hint.

[ExpressionMethod("JoinGlobalAntiTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinGlobalAntiHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinGlobalAnyHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse GLOBAL ANY join hint.

[ExpressionMethod("JoinGlobalAnyHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinGlobalAnyHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinGlobalAnyHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse GLOBAL ANY join hint.

[ExpressionMethod("JoinGlobalAnyTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinGlobalAnyHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinGlobalAsOfHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse GLOBAL ASOF join hint.

[ExpressionMethod("JoinGlobalAsOfHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinGlobalAsOfHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinGlobalAsOfHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse GLOBAL ASOF join hint.

[ExpressionMethod("JoinGlobalAsOfTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinGlobalAsOfHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinGlobalHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse GLOBAL join hint.

[ExpressionMethod("JoinGlobalHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinGlobalHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinGlobalHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse GLOBAL join hint.

[ExpressionMethod("JoinGlobalTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinGlobalHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinGlobalOuterHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse GLOBAL OUTER join hint.

[ExpressionMethod("JoinGlobalOuterHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinGlobalOuterHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinGlobalOuterHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse GLOBAL OUTER join hint.

[ExpressionMethod("JoinGlobalOuterTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinGlobalOuterHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinGlobalSemiHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse GLOBAL SEMI join hint.

[ExpressionMethod("JoinGlobalSemiHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinGlobalSemiHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinGlobalSemiHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse GLOBAL SEMI join hint.

[ExpressionMethod("JoinGlobalSemiTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinGlobalSemiHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinOuterHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse OUTER join hint.

[ExpressionMethod("JoinOuterHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinOuterHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinOuterHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse OUTER join hint.

[ExpressionMethod("JoinOuterTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinOuterHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

JoinSemiHint<TSource>(IClickHouseSpecificQueryable<TSource>)

Adds a ClickHouse SEMI join hint.

[ExpressionMethod("JoinSemiHintImpl")]
public static IClickHouseSpecificQueryable<TSource> JoinSemiHint<TSource>(this IClickHouseSpecificQueryable<TSource> query) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource

JoinSemiHint<TSource>(IClickHouseSpecificTable<TSource>)

Adds a ClickHouse SEMI join hint.

[ExpressionMethod("JoinSemiTableHintImpl")]
public static IClickHouseSpecificTable<TSource> JoinSemiHint<TSource>(this IClickHouseSpecificTable<TSource> table) where TSource : notnull

Parameters

table IClickHouseSpecificTable<TSource>

Returns

IClickHouseSpecificTable<TSource>

Type Parameters

TSource

SettingsHint<TSource>(IClickHouseSpecificQueryable<TSource>, string, params object?[])

[ExpressionMethod("ClickHouse", "SettingsHintImpl")]
public static IClickHouseSpecificQueryable<TSource> SettingsHint<TSource>(this IClickHouseSpecificQueryable<TSource> query, string hintFormat, params object?[] hintParameters) where TSource : notnull

Parameters

query IClickHouseSpecificQueryable<TSource>

hintFormat string

hintParameters object[]

Returns

IClickHouseSpecificQueryable<TSource>

Type Parameters

TSource