Table of Contents

Class StringAggregateExtensions

Namespace
LinqToDB
Assembly
linq2db.dll
public static class StringAggregateExtensions
Inheritance
StringAggregateExtensions

Methods

OrderByDescending<T, TR>(IAggregateFunctionNotOrdered<T, TR>) 

[Sql.Extension("WITHIN GROUP ({order_by_clause})", TokenName = "aggregation_ordering", ChainPrecedence = 2)]
[Sql.Extension("ORDER BY {order_item, ', '}", TokenName = "order_by_clause")]
[Sql.Extension("{aggregate} DESC", TokenName = "order_item")]
public static Sql.IAggregateFunction<T, TR> OrderByDescending<T, TR>(this Sql.IAggregateFunctionNotOrdered<T, TR> aggregate)

Parameters

aggregate Sql.IAggregateFunctionNotOrdered<T, TR>

Returns

Sql.IAggregateFunction<T, TR>

Type Parameters

T
TR

OrderByDescending<T, TR, TKey>(IAggregateFunctionNotOrdered<T, TR>, Expression<Func<T, TKey>>) 

[Sql.Extension("WITHIN GROUP ({order_by_clause})", TokenName = "aggregation_ordering", ChainPrecedence = 2)]
[Sql.Extension("ORDER BY {order_item, ', '}", TokenName = "order_by_clause")]
[Sql.Extension("{expr} DESC", TokenName = "order_item")]
public static Sql.IAggregateFunctionOrdered<T, TR> OrderByDescending<T, TR, TKey>(this Sql.IAggregateFunctionNotOrdered<T, TR> aggregate, Expression<Func<T, TKey>> expr)

Parameters

aggregate Sql.IAggregateFunctionNotOrdered<T, TR>
expr Expression<Func<T, TKey>>

Returns

Sql.IAggregateFunctionOrdered<T, TR>

Type Parameters

T
TR
TKey

OrderBy<T, TR>(IAggregateFunctionNotOrdered<T, TR>) 

[Sql.Extension("WITHIN GROUP ({order_by_clause})", TokenName = "aggregation_ordering", ChainPrecedence = 2)]
[Sql.Extension("ORDER BY {order_item, ', '}", TokenName = "order_by_clause")]
[Sql.Extension("{aggregate}", TokenName = "order_item")]
public static Sql.IAggregateFunction<T, TR> OrderBy<T, TR>(this Sql.IAggregateFunctionNotOrdered<T, TR> aggregate)

Parameters

aggregate Sql.IAggregateFunctionNotOrdered<T, TR>

Returns

Sql.IAggregateFunction<T, TR>

Type Parameters

T
TR

OrderBy<T, TR, TKey>(IAggregateFunctionNotOrdered<T, TR>, Expression<Func<T, TKey>>) 

[Sql.Extension("WITHIN GROUP ({order_by_clause})", TokenName = "aggregation_ordering", ChainPrecedence = 2)]
[Sql.Extension("ORDER BY {order_item, ', '}", TokenName = "order_by_clause")]
[Sql.Extension("{expr}", TokenName = "order_item")]
public static Sql.IAggregateFunctionOrdered<T, TR> OrderBy<T, TR, TKey>(this Sql.IAggregateFunctionNotOrdered<T, TR> aggregate, Expression<Func<T, TKey>> expr)

Parameters

aggregate Sql.IAggregateFunctionNotOrdered<T, TR>
expr Expression<Func<T, TKey>>

Returns

Sql.IAggregateFunctionOrdered<T, TR>

Type Parameters

T
TR
TKey

ThenByDescending<T, TR, TKey>(IAggregateFunctionOrdered<T, TR>, Expression<Func<T, TKey>>) 

[Sql.Extension("{expr} DESC", TokenName = "order_item")]
public static Sql.IAggregateFunctionOrdered<T, TR> ThenByDescending<T, TR, TKey>(this Sql.IAggregateFunctionOrdered<T, TR> aggregate, Expression<Func<T, TKey>> expr)

Parameters

aggregate Sql.IAggregateFunctionOrdered<T, TR>
expr Expression<Func<T, TKey>>

Returns

Sql.IAggregateFunctionOrdered<T, TR>

Type Parameters

T
TR
TKey

ThenBy<T, TR, TKey>(IAggregateFunctionOrdered<T, TR>, Expression<Func<T, TKey>>) 

[Sql.Extension("{expr}", TokenName = "order_item")]
public static Sql.IAggregateFunctionOrdered<T, TR> ThenBy<T, TR, TKey>(this Sql.IAggregateFunctionOrdered<T, TR> aggregate, Expression<Func<T, TKey>> expr)

Parameters

aggregate Sql.IAggregateFunctionOrdered<T, TR>
expr Expression<Func<T, TKey>>

Returns

Sql.IAggregateFunctionOrdered<T, TR>

Type Parameters

T
TR
TKey

ToValue<T, TR>(IAggregateFunction<T, TR>) 

[Sql.Extension("Oracle", "WITHIN GROUP (ORDER BY ROWNUM)", TokenName = "aggregation_ordering", ChainPrecedence = 0, IsAggregate = true)]
[Sql.Extension("Oracle.Native", "WITHIN GROUP (ORDER BY ROWNUM)", TokenName = "aggregation_ordering", ChainPrecedence = 0, IsAggregate = true)]
[Sql.Extension("", ChainPrecedence = 0, IsAggregate = true)]
public static TR ToValue<T, TR>(this Sql.IAggregateFunction<T, TR> aggregate)

Parameters

aggregate Sql.IAggregateFunction<T, TR>

Returns

TR

Type Parameters

T
TR