Maybe not the best solution, but you can create a filter on the child collection and enable it for that query.
On Wed, May 25, 2011 at 9:57 AM, Mauro D. <[email protected]> wrote: > Hi all, > i'm trying to create a query (with no type preferences HQL, Query, > QueryOver) that gives me all master entity but populate only the > entity detail in the Details collection that has a property equal > zero. > > No lazy loading allowed. > > The current version is this: > > Session.CreateQuery("select st from StatoRete st left join fetch > st.Dettagli dett where dett.Done=0 and st.Data<:data") > .SetDateTime("data",DateTime.Now.AddMinutes(parametri.GetTempoAccorpamento())) > .SetResultTransformer(new > DistinctRootEntityResultTransformer()).List<StatoRete>(); > > But I don't get all StatoRete that don't have any Detail with Done=0 > so I lose some entity. > > > There's a solution for this? > > Thanks > > -- > 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. > > -- 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.
