Class NotExists

Namespace

YndigoBlue.Velocity.Functions

Assembly

YndigoBlue.Velocity.dll

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

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

Inheritance

object

Function

NotExists

Implements

IElement

ICheckItem

IDefaultItem

IFilterItem

Remarks

The NOT EXISTS operator returns true if the subquery returns zero rows, and false if it returns one or more rows. Like EXISTS, it uses short-circuit evaluation for efficiency. This is useful for finding records without related data, implementing anti-joins, or filtering based on the absence of matching conditions. NOT EXISTS is often more readable and efficient than LEFT JOIN with NULL checks for finding unmatched records.

Constructors

NotExists(IEnumerable<IElement>)

Initializes a new instance of NOT EXISTS for multiple elements.

NotExists(IElement)

Initializes a new instance of NOT EXISTS for a single element.