Table of Contents

Constructor Case

Namespace
YndigoBlue.Velocity.Model
Assembly
YndigoBlue.Velocity.dll

Case()

Creates a searched case expression with no result-set alias.

public Case()

Remarks

Use this form when the case expression is nested inside another expression, passed to a function or aggregate, or used as an assigned value — anywhere the result does not need naming. Add branches with When(IFilterItem, IElement).

Case(string)

Creates a searched case expression with a result-set alias.

public Case(string name)

Parameters

name string

The alias for this expression when it appears in a SELECT clause.

Remarks

Add branches with When(IFilterItem, IElement). Each case expression in a single SELECT clause needs its own distinct alias.

Case(IElement)

Creates a simple case expression that compares the supplied operand against each branch value.

public Case(IElement operand)

Parameters

operand IElement

The column, function or expression compared against each branch value.

Remarks

Add branches with When(IElement, IElement).

Case(string, IElement)

Creates a simple case expression with a result-set alias.

public Case(string name, IElement operand)

Parameters

name string

The alias for this expression when it appears in a SELECT clause.

operand IElement

The column, function or expression compared against each branch value.

Remarks

Add branches with When(IElement, IElement).