The only way that you're going to load a large graph effectively is
through using several queries like so (anyone please correct me if I'm
wrong):
var query = session.CreateCriteria<Entity>()
.Add(Restrictions.IdEq(42))
.SetFetchMode("ParentEntity", FetchMode.Join)
.FutureValue<Entity>();
session.CreateCriteria<Entity>()
.Add(Restrictions.IdEq(42))
.SetFetchMode("ChildEntities", FetchMode.Join)
.SetFetchMode("ChildEntities.AnotherEntity", FetchMode.Join)
.SetFetchMode("ChildEntities.GrandChildEntities", FetchMode.Join)
.FutureValue<Entity>();
session.CreateCriteria<Entity>()
.Add(Restrictions.IdEq(42))
.SetFetchMode("MoreChildEntities", FetchMode.Join)
.FutureValue<Entity>();
Entity entity = query.Value;
This will result in 3 queries that get sent down all at once.
NHibernate will then be smart and load up the desired collections/
entities. Specifically, the result of this query would be an Entity
entity with an ID of 42 with its many-to-one ParentEntity loaded, one-
to-many MoreChildEntities loaded and one-to-many ChildEntities
collection loaded with each one having its many-to-one AnotherEntity
and one-to-many GrandChildEntities collections loaded. This also
works with using Future instead of FutureValue.
>From my experience this has been fairly performant for me (especially
with the new Future calls), even with legacy databases with tables
that have a ton of columns.
On Feb 21, 12:45 am, cliff <[email protected]> wrote:
> I just found this thread:
>
> http://groups.google.com/group/nhusers/browse_thread/thread/be7e0fb58...
>
> and I was wondering if there was a better solution than using a set.
> The issue i have with sets is that all items must be loaded into it
> before you can add a new item. This is not very performant with a
> large number of items. Is there a way to achieve the non-duplication
> without using a set?
>
> thanks
>
> cliff
--
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.
