MssqlCycleHandling enum

What a hierarchy walk does when the data has a cycle.

A category that is its own ancestor is a data bug; the choice is to report it or to stop walking.

Inheritance

• Object
• Enum
• MssqlCycleHandling

Available extensions

• EnumName

Values

error → const MssqlCycleHandling

Let the recursion hit its ceiling and fail: SQL Server raises error 530 naming MAXRECURSION.

The default. A cycle in a category tree means the data is wrong, and a query that quietly returns a partial answer hides it — the report looks right and is short by a branch.

skipVisited → const MssqlCycleHandling

Carry the path walked so far and refuse to re-enter a key already on it.

Costs a growing nvarchar(max) per row and a CHARINDEX per candidate, which is real; it is the right trade only where a cycle is known to be possible and the rest of the tree still has to come back.

Properties

hashCode → int

The hash code for this object.

no setter, inherited

index → int

A numeric identifier for the enumerated value.

no setter, inherited

name → String

Available on Enum, provided by the EnumName extension

The name of the enum value.

no setter

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited

Constants

values → const List<MssqlCycleHandling>

A constant List of the values in this enum, in order of their declaration.