Table of Contents

Class YdbHints

Namespace
LinqToDB.DataProvider.Ydb
Assembly
linq2db.dll

SQL hints for YDB (YQL). See:

  • SQL hints syntax: comments starting with "--+".
  • SELECT-level hints: 'unique' / 'distinct' right after SELECT.
public static class YdbHints
Inheritance
YdbHints
Inherited Members

Remarks

Emits YQL hint comment lines like: --+ unique(col1 col2) --+ distinct()

Fields

Distinct

public const string Distinct = "distinct"

Field Value

string

Unique

public const string Unique = "unique"

Field Value

string

Methods

DistinctHint<TSource>(IYdbSpecificQueryable<TSource>, params string[])

[ExpressionMethod("DistinctHintImpl")]
public static IYdbSpecificQueryable<TSource> DistinctHint<TSource>(this IYdbSpecificQueryable<TSource> query, params string[] columns) where TSource : notnull

Parameters

query IYdbSpecificQueryable<TSource>
columns string[]

Returns

IYdbSpecificQueryable<TSource>

Type Parameters

TSource

DistinctHint<TSource>(IQueryable<TSource>, params string[])

[ExpressionMethod("DistinctHintQImpl")]
public static IYdbSpecificQueryable<TSource> DistinctHint<TSource>(this IQueryable<TSource> query, params string[] columns) where TSource : notnull

Parameters

query IQueryable<TSource>
columns string[]

Returns

IYdbSpecificQueryable<TSource>

Type Parameters

TSource

QueryHint<TSource>(IYdbSpecificQueryable<TSource>, string, params string[])

Generic query-hint injector for YDB/YQL.

[IsQueryable]
[Sql.QueryExtension("YDB", Sql.QueryExtensionScope.SubQueryHint, typeof(YdbHints.YdbQueryHintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static IYdbSpecificQueryable<TSource> QueryHint<TSource>(this IYdbSpecificQueryable<TSource> source, string hint, params string[] values) where TSource : notnull

Parameters

source IYdbSpecificQueryable<TSource>
hint string
values string[]

Returns

IYdbSpecificQueryable<TSource>

Type Parameters

TSource

QueryHint<TSource>(IQueryable<TSource>, string, params string[])

[IsQueryable]
[Sql.QueryExtension("YDB", Sql.QueryExtensionScope.SubQueryHint, typeof(YdbHints.YdbQueryHintExtensionBuilder))]
[Sql.QueryExtension(null, Sql.QueryExtensionScope.None, typeof(NoneExtensionBuilder))]
public static IYdbSpecificQueryable<TSource> QueryHint<TSource>(this IQueryable<TSource> source, string hint, params string[] values) where TSource : notnull

Parameters

source IQueryable<TSource>
hint string
values string[]

Returns

IYdbSpecificQueryable<TSource>

Type Parameters

TSource

UniqueHint<TSource>(IYdbSpecificQueryable<TSource>, params string[])

[ExpressionMethod("UniqueHintImpl")]
public static IYdbSpecificQueryable<TSource> UniqueHint<TSource>(this IYdbSpecificQueryable<TSource> query, params string[] columns) where TSource : notnull

Parameters

query IYdbSpecificQueryable<TSource>
columns string[]

Returns

IYdbSpecificQueryable<TSource>

Type Parameters

TSource

UniqueHint<TSource>(IQueryable<TSource>, params string[])

[ExpressionMethod("UniqueHintQImpl")]
public static IYdbSpecificQueryable<TSource> UniqueHint<TSource>(this IQueryable<TSource> query, params string[] columns) where TSource : notnull

Parameters

query IQueryable<TSource>
columns string[]

Returns

IYdbSpecificQueryable<TSource>

Type Parameters

TSource