I might be not fulling understanding what you're asking here, but if what you
want to do is just retrieve all descendants based on some kind of separated
path, can't you just do that with an NHibernate criteria query? Something like:
var descendants = Session.CreateCriteria<OrgUnit>()
.Add(Restrictions.InsensitiveLike("HierarchicalPath", pathRootSegment,
MatchMode.BeginsWith)**
.List<OrgUnit>();
Assuming the path is something like: Parent/Child/Child/Child/Child etc, then
for the pathRootSegment = "Parent/Child" this would match:
Parent/Child/
Parent/Child/Child/
Parent/Child/Child/Child/
Parent/Child/Child/Child/Child
Then you could just use a HasMany mapping on each OrgUnit if you wanted to
interrogate the direct children of any given unit.
Again, sorry if I'm misunderstood the question.
** I'm not sure if that's the correct match mode, but there is a "begins with"
equivalent, and if your case is constant, then you can just use Like instead of
InsensitiveLike.
Thanks,
Geoff.
On Friday, 10 August 2012 at 5:46 AM, Michael Vogt wrote:
> Hello,
>
> I use fluent and nHibernate for about 2 months now but can not find the right
> documentation for my problem:
>
> I habe a table "OrgUnits" wich represents a tree that can easy be queried. I
> have the following columns:
>
> Id (Uniqueidentifier)
> Name (string)
> ParentOrgUnitId (uniqueidentifier)
> HierarchicalPath (string - the complete path is resolved using a configured
> seperator)
>
> I want to avoid any recursion and have a query, based on the HierarchicalPath
> column that can select all descendant org units (not only the children). I
> need this recursion-less query to resolve some connected ACL's (Access
> Control Lists).
>
> I think there is some solution to query for all descendants in linq, but: How
> can I MAP this descendant org units. There is no Primary-Foreign Key
> relationship to all descendants. It is easy to create an SQL to query for all
> descendents (the select is cheap if you have an index in "HierarchicalPath":
>
> I do not know if I can tell the fluent "HasMany" statement not to use any
> primary-foreign-key relationship but instead give some "StartsWith" on the
> HierarchicalPath column.
>
> Here is the SQL that collects all org units I want to be returned by the
> "Descendants" mapping. This selects all descendant org units including
> "MyRoot".
>
> Is it possible to do a mapping (self-mapping) that serves a
> IEnumerable<OrgUnit> property with all org units defined in the SQL below
> using Fluent?
>
> select d.* from OrgUnits o left join OrgUnits d on
> CharIndex(o.HierarchicalPath,d.HierarchicalPath)=1 where o.Name='MyRoot'
>
> --
> You received this message because you are subscribed to the Google Groups
> "Fluent NHibernate" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/fluent-nhibernate/-/I5w4iWDx9sQJ.
> To post to this group, send email to fluent-nhibernate@googlegroups.com
> (mailto:fluent-nhibernate@googlegroups.com).
> To unsubscribe from this group, send email to
> fluent-nhibernate+unsubscr...@googlegroups.com
> (mailto:fluent-nhibernate+unsubscr...@googlegroups.com).
> For more options, visit this group at
> http://groups.google.com/group/fluent-nhibernate?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Fluent NHibernate" group.
To post to this group, send email to fluent-nhibernate@googlegroups.com.
To unsubscribe from this group, send email to
fluent-nhibernate+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/fluent-nhibernate?hl=en.
