Provided your database can implement prefix string searches as an indexed range search, materializing the path is conceptually simple and avoids the write/update overhead of nested sets. I used this ...
I'm trying to figure out the best (maintainable, efficient, etc.) way to store and retrieve an ordered tree in a SQL database.<BR><BR>I've got an application (C# WinForms) that has a TreeView which ...