I know that the nested dialing model does not apply to C # or LINQ directly ... this is what I use to develop my web application.
For hierarchical data (categories with subcategories in my case) I am currently using something similar to the Adjacency list model. At the moment I have only 2 levels of categories, but I would like to take them further and allow n category levels using a nested set model.
I don't quite understand how to use it in a C # context. Here is an article I'm reading on a nested dialing model . Although this article found out that I am confusing some, do I still have a big one ??? in the head:
- Inserts, updates or deletes tedious categories? It looks like the left and right numbers will require re-numbering ... what do LINQ queries look like for the following scenarios?
- Delete child node (recalculate all node values left / right)
- Delete parent node (what are you doing with orphans?)
- Move the node child to another parent node (change numbered)
If my understanding is correct, in all cases the child values of the node left / right will always be between the parent values of the node left / right, is it correct?
It seems easy enough, if only the categories were static ... Most likely, I need to spend more time to plunge into the concept.
Any help is much appreciated!