Thanks for the great post.

I have a question though.

In this solution, you have to first load everything in the memory then do the querying so it will not be on the database side.

Let's make an example.

You have buildings with rooms and floors. The rooms are under floors and floors under building and you are calling the self-referencing entity, resource. How would you get the rooms inside a specific building? or if you have one room how do you get the building name in the tree?