My table is as follows. Note that I don't have any control over the table structure as it's from a vendor.
Id (PK) Name ParentId The table in question currently has 500k records. I'm not sure if I should model my table as a flat entity or model it with self- referencing. Or if I should model the table with a one to many relationship with itself. However, that could get pretty costly if I keep loop[ing through the children depending on how high in the tree I am. Thank you. On Jul 24, 10:57 am, Mike <[email protected]> wrote: > How can I use Oracle's "Connect By" clause in a detached criteria? I > already have a working query using DetachedCriteria but now I need to > add the following sub query that utilizes the "start with" and > "connect by" clause. Is there any way I can possibly do something > like... > > .Add(Subqueries.In("p.StructureNumber", "query that fetches all > children from a given parent written in oracle")) -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
