NHibernate.Test.MultipleCollectionFetchTest 2009/5/21 Fabio Maulo <[email protected]>
> send a test case here, I would like to see the code/mappings because we > have enough tests about this matter > > > 2009/5/21 chewzoey <[email protected]> > >> >> from CameraMount m left join fetch m.Presets >> and >> select m from CameraMount m left join fetch m.Presets >> >> have the same result. >> >> On May 21, 11:23 am, Fabio Maulo <[email protected]> wrote: >> > wrong HQL to be compared with that CriteriaFor second time... >> > select m from CameraMount m left join fetch m.Presets >> > >> > 2009/5/21 chewzoey <[email protected]> >> > >> > >> > >> > >> > >> > > The mapping >> > > <set name="Presets" table="CAMERA_PRESET_TBL"> >> > > <key column="LNKID_CAMERA_MOUNT"/> >> > > <one-to-many class="CameraPreset, Model"/> >> > > </set> >> > >> > > session.CreateQuery("from CameraMount m left join fetch m.Presets >> > > ").List(results); >> > >> > > The above hql returns a cartesian product of 180 rows ... each row >> > > contains the parent and child record, the parent record being >> > > duplicated for each child. >> > >> > > session.CreateCriteria(typeof(CameraMount)). >> > > SetFetchMode("CameraPreset", FetchMode.Join). >> > > List(results1); >> > >> > > The above criteria query returns 5(parent) rows with its children (the >> > > set) initialized. >> > >> > -- >> > Fabio Maulo >> >> >> > > > -- > Fabio Maulo > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
