CODEWITHSUNDEEP
nhibernate
gt124
gt124

Reputation: 1258

nhibernate queryover not loading eagerly with a many to many joinalias

I'm trying to eager load roles in many to many collection off of my User object.

Role role = null;
IQueryOver<User, User> query = session.QueryOver<User>()
                                .Fetch( p => p.Roles).Eager
                                .JoinAlias( q => q.Roles, () => role)
                                .Where(() => role.Active == true);

leaves me with user objects that have uninitialized roles members. If I remove the joinalias, they are initialized just fine. Is this just an NH3 bug or am I doing something wrong?

Upvotes: 4

Views: 4256

Answers (2)

Sly
Sly

Reputation: 15217

Another way to make eager load is to set LeftOuterJoin. It helped to us in a similar scenario 

Role role = null;
IQueryOver<User, User> query = session.QueryOver<User>().Fetch( p => p.Roles).Eager
                                                        .JoinAlias( q => q.Roles, () => role, JoinType.LeftOuterJoin)
                                                        .Where(() => role.Active == true);

Upvotes: 13

Diego Mijelshon
Diego Mijelshon

Reputation: 52725

That's the expected behavior. If you use JoinAlias, you'll be filtering the collection elements, so it can't be initialized.

You need to use a subquery for filtering if you intend to use eager loading. on the same collection.

Upvotes: 1

Related Questions