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.

2 articles #hierarchies ×

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 20 aug. 2026 18 min read

.NET / Architecture

Game of Thrones as a data model: parties, typed relationships, and a TreeList of alliances

Using a domain everyone knows to stress-test a stakeholder model — people, houses, sworn banners and shifting alliances — and rendering the result as a navigable tree.

Pinned 14 aug. 2026 33 min read