Class Exists

Namespace

YndigoBlue.Velocity.Functions

Assembly

YndigoBlue.Velocity.dll

Represents the EXISTS operator that tests whether a subquery returns any rows.

public class Exists : Function, IElement, ICheckItem, IDefaultItem, IFilterItem

Inheritance

object

Function

Exists

Implements

IElement

ICheckItem

IDefaultItem

IFilterItem

Remarks

The EXISTS operator returns true if the subquery returns one or more rows, and false if it returns no rows. EXISTS is particularly efficient because it stops processing as soon as it finds a matching row (short-circuit evaluation). This is useful for testing relationships, conditional filtering based on related data existence, or implementing semi-joins. Unlike IN, EXISTS can work with multiple columns and complex conditions.

Constructors

Exists(IEnumerable<IElement>)

Initializes a new instance of EXISTS for multiple elements.

Exists(IElement)

Initializes a new instance of EXISTS for a single element.