Open SimonJF opened 5 years ago
receptorFamilies.links queries data which is hierarchical. There's no neat way to do this with the current LINQ implementation, since recursion is disallowed. Currently, the implementation does n queries, where n is the depth of the tree.
receptorFamilies.links
n
Oracle has a CONNECT BY statement, which seems to be related: https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries003.htm
CONNECT BY
Similarly, Postgres has a RECURSIVE query: https://stackoverflow.com/questions/24898681/what-is-the-equivalent-postgresql-syntax-to-oracles-connect-by-start-with
RECURSIVE
This would take quite a lot of work (and probably research).
receptorFamilies.linksqueries data which is hierarchical. There's no neat way to do this with the current LINQ implementation, since recursion is disallowed. Currently, the implementation doesnqueries, wherenis the depth of the tree.Oracle has a
CONNECT BYstatement, which seems to be related: https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries003.htmSimilarly, Postgres has a
RECURSIVEquery: https://stackoverflow.com/questions/24898681/what-is-the-equivalent-postgresql-syntax-to-oracles-connect-by-start-withThis would take quite a lot of work (and probably research).