I don't use the criteria API so nothing jumps out unfortunately. You could try writing the query using HQL to determine whether the problem is your usage of the criteria API.
You could also try asking on the nhibernate users<http://groups.google.com/group/nhusers/> mailing list, your question is more about NH usage than the FNH mappings (your mappings look fine). On Mon, Sep 13, 2010 at 3:48 PM, Alistair <alistair.burro...@gmail.com>wrote: > Hi, > > I have the following relationship: > > Page HasMany Areas. > > Mapping: > > public class PageMapping : IAutoMappingOverride<Page> > { > public void Override(AutoMapping<Page> mapping) > { > mapping.HasMany(p => p.Areas) > .KeyColumn("PageId"); > } > } > > public class AreaMapping : IAutoMappingOverride<Area> > { > public void Override(AutoMapping<Area> mapping) > { > mapping.References(a => a.Page) > .Column("PageId"); > } > } > > However: I can't force it to eager load when I query the database, > even though the query will return all the data as expected. > > return Session.CreateCriteria(typeof (Page)) > .CreateAlias("Areas", "area") > .SetFetchMode("area", FetchMode.Join) > .Add(Restrictions.Eq("Name", pageName)) > .UniqueResult<Page>(); > > So then when I call: > > homePage.Areas > > I query is sent to the database to fetch the areas for the home page, > even though they did come back in the query results. > > I am using Sharp Architecture 1.6 btw. > > Am I missing something? > > -- > You received this message because you are subscribed to the Google Groups > "Fluent NHibernate" group. > To post to this group, send email to fluent-nhibern...@googlegroups.com. > To unsubscribe from this group, send email to > fluent-nhibernate+unsubscr...@googlegroups.com<fluent-nhibernate%2bunsubscr...@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-nhibern...@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.
