Class PivotExpression

Namespace

NextORM.Core

Assembly

nextorm.core.dll

A PIVOT/UNPIVOT source: the inner source whose rows/columns are reshaped, together with the aggregate/values (PIVOT) or the value/name columns and column list (UNPIVOT). Stored on Pivot and rendered by the provider that supports the construct (see Pivot / Pivot).

public sealed class PivotExpression

Inheritance

object

PivotExpression

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

EntityBuilderExtensions.AsEntityBuilder<T>(object?)

Properties

Aggregate

The aggregate applied by a PIVOT.

public PivotAggregate Aggregate { get; }

Property Value

PivotAggregate

AggregateColumn

The aggregated column expression of a PIVOT, or null for UNPIVOT.

public LambdaExpression? AggregateColumn { get; }

Property Value

LambdaExpression

Columns

The IN (...) source columns of an UNPIVOT; empty for PIVOT.

public IReadOnlyList<UnpivotColumn> Columns { get; }

Property Value

IReadOnlyList<UnpivotColumn>

ForColumn

The FOR column expression of a PIVOT, or null for UNPIVOT.

public LambdaExpression? ForColumn { get; }

Property Value

LambdaExpression

Inner

The source whose rows/columns are reshaped (a table, table-valued function or subquery).

public FromExpression Inner { get; }

Property Value

FromExpression

InnerEntityType

The entity type of Inner, used to resolve the pivot column expressions.

public Type InnerEntityType { get; }

Property Value

Type

IsUnpivot

true for an UNPIVOT; false for a PIVOT.

public bool IsUnpivot { get; }

Property Value

bool

UnpivotNameColumn

The output name-column name of an UNPIVOT, or null for PIVOT.

public string? UnpivotNameColumn { get; }

Property Value

string

UnpivotValueColumn

The output value-column name of an UNPIVOT, or null for PIVOT.

public string? UnpivotValueColumn { get; }

Property Value

string

Values

The IN (...) values of a PIVOT; empty for UNPIVOT.

public IReadOnlyList<PivotValue> Values { get; }

Property Value

IReadOnlyList<PivotValue>