❔ [EFCore] What is the right approach to generate hierarchy id for new child entity?
I Use SQLServer & EF Core. been struggling to find the right approach to generate new h-id for new child entities for a while now. and most approaches online are just straight up inserting duplicates or doing multiple queries with really possible scare-y edge cases that can cause alot of trouble.
