Interface IPivotRenderer

Namespace

NextORM.Core

Assembly

nextorm.core.dll

A dialect's renderer for the native PIVOT/UNPIVOT pair (SQL Server). The object's presence is the capability.

public interface IPivotRenderer

Extension Methods

EntityBuilderExtensions.AsEntityBuilder<T>(object?)

Methods

RenderPivot(PivotExpression, string, string, string, string, KeywordCase)

Renders the native PIVOT construct over the already-rendered source, with the already-rendered aggregateColumn and forColumn fragments and the result alias.

string RenderPivot(PivotExpression pivot, string source, string aggregateColumn, string forColumn, string alias, KeywordCase keywordCase = KeywordCase.Lower)

Parameters

pivot PivotExpression

source string

aggregateColumn string

forColumn string

alias string

keywordCase KeywordCase

Returns

string

RenderUnpivot(PivotExpression, string, string, KeywordCase)

Renders the native UNPIVOT construct over the already-rendered source and the result alias.

string RenderUnpivot(PivotExpression pivot, string source, string alias, KeywordCase keywordCase = KeywordCase.Lower)

Parameters

pivot PivotExpression

source string

alias string

keywordCase KeywordCase

Returns

string