Regira Engineering Blog

Notes on .NET, TypeScript & Vue

Patterns, gotchas and small wins from building the Regira packages and modules — entity pipelines, editorial front-ends and everything between.

1 article #recursive-cte ×
Data & EF Core / Architecture

Querying hierarchies at any depth: recursive SQL functions meet an in-memory TreeList

Three escalating strategies for self-referencing entities in EF Core — from ParentId filters to recursive CTE table-valued functions composed inside your query pipeline.

Pinned 18 min read