且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

渴望负荷自引用表

更新时间:2023-02-02 22:41:48

没有,这是不可能的。试想一下:所有的LINQ to Entities查询翻译成SQL。其中的SQL语句包括自引用层次无限的深度?在标准的SQL,没有一个。如果有这种在T-SQL的延伸,我不知道它是什么,我不认为EF供应商做,无论是。

No, it isn't possible. Consider: All LINQ to Entities queries are translated into SQL. Which SQL statement includes an unlimited depth in a self-referencing hierarchy? In standard SQL, there isn't one. If there's an extension for this in T-SQL, I don't know what it is, and I don't think EF providers do, either.