Struct SqlWindowFrameBoundary

Namespace

LfrlAnvil.Sql.Expressions.Traits

Assembly

LfrlAnvil.Sql.Core.dll

Represents a boundary of an SqlWindowFrameNode.

public readonly struct SqlWindowFrameBoundary

Inherited Members

ValueType.Equals(object)

ValueType.GetHashCode()

ValueType.ToString()

object.Equals(object, object)

object.GetType()

object.ReferenceEquals(object, object)

Fields

CurrentRow

Represents a CurrentRow boundary.

public static readonly SqlWindowFrameBoundary CurrentRow

Field Value

SqlWindowFrameBoundary

UnboundedFollowing

Represents an unlimited Following boundary.

public static readonly SqlWindowFrameBoundary UnboundedFollowing

Field Value

SqlWindowFrameBoundary

UnboundedPreceding

Represents an unlimited Preceding boundary.

public static readonly SqlWindowFrameBoundary UnboundedPreceding

Field Value

SqlWindowFrameBoundary

Properties

Direction

SqlWindowFrameBoundaryDirection of this boundary.

public SqlWindowFrameBoundaryDirection Direction { get; }

Property Value

SqlWindowFrameBoundaryDirection

Expression

Optional offset expression.

public SqlExpressionNode? Expression { get; }

Property Value

SqlExpressionNode

Methods

Following(SqlExpressionNode)

Creates a new SqlWindowFrameBoundary instance with Following direction and a custom offset Expression.

[Pure]
public static SqlWindowFrameBoundary Following(SqlExpressionNode expression)

Parameters

expression SqlExpressionNode

Offset expression to use.

Returns

SqlWindowFrameBoundary

New SqlWindowFrameBoundary instance.

Preceding(SqlExpressionNode)

Creates a new SqlWindowFrameBoundary instance with Preceding direction and a custom offset Expression.

[Pure]
public static SqlWindowFrameBoundary Preceding(SqlExpressionNode expression)

Parameters

expression SqlExpressionNode

Offset expression to use.

Returns

SqlWindowFrameBoundary

New SqlWindowFrameBoundary instance.