Question

我使用 C# ASP. NET, 并需要通过应用程序来使用循环。我目前使用 Linq 给实体,并在网上进行广泛搜索,但无法找到和大意地进行循环查询。我不知道循环会达到多少个级别。

Answer 1

我有一个类似的问题要解决,我最后写了一个助手函数,该函数会从我的数据源中反复出现,并按顺序返回一个包含所有项目的IE倍数。然而,就我而言,数据源是线性。如果你的树结构更像树结构,并且必须按等级显示,这将不起作用。

Answer 2

我不知道你到底有什么问题我不知道其他ORMs在做什么

我认为Nhembernate应该解决大部分的问题直接向前。

Use Lazy-loading: children are lazily loaded. You don t need something like recursive queries, which are not possible in SQL.
Navigation with lazy loading works in both directions. So you can get a node from the database using a simple query and navigate to its parent.
In many cases it makes sense to add some additional redundancy to the recursive graph. For instance a reference to the root node, which allows queries to trees which have at least one node matching a criterion. Or the depth of a node (its distance to the root). Or the number of child nodes and so on. Whatever you need for your queries.