NHibernate Fetch when querying for single object

Question

I'm trying to optimize an NHibernate query:

var profile = dc.Profiles.FirstOrDefault(p => p.IdProfile == idProfile);

I would like it to load a collection of Rights. I did this:

var profile = dc.Profiles.Fetch(x => x.Rights).FirstOrDefault(p => p.IdProfile == idProfile);

The results were totally different from what I expected - instead of getting single Profile with rights I got single profile with single right!

How can I fix it?

Answer 1

You can use like this

var profile = dc.Profiles.Where(p => p.IdProfile == idProfile).Select(x => x.Rights);