Thanks for your reply. I've already tried it. The problem with this method is that I will not have access to other properties on my main class. In my real application the main class has more properties which I need to be lazy loaded.
If my class has list of cars for example then I wouldnt be able to load parent cars. Thanks On May 5, 4:57 pm, John Davidson <[email protected]> wrote: > You need to use projections to limit the fields returned > > session.CreateCriteria(typeof(Parent)) .SetFetchMode("children", > FetchMode.Select); > .CreateCriteria("children").Add(Subqueries.PropertyIn("Id", > {1,2,3,4})).SetProjections(Projections.List().Add(Projections.Property("Id")).Add(Projections.Property("Name"))) > .List(); > > John Davidson > > > > On Wed, May 5, 2010 at 11:43 AM, Sandra <[email protected]> wrote: > > Hi all, > > > I'm having a problem with NHIbernate and was hoping you could help. > > Not sure if it's a bug in NHibernate or not. > > > I have an object 'Parent' which has a list of Children: (many-to-many > > relation) > > > class Parent {Id, Name, IList<Child> children} > > class Child {Id, Name} > > > I need to select all parents where there is a condition for their > > children but I do not want to get duplicate rows (don't want the > > children details to appear in select list) > > > Here is the code: > > > session.CreateCriteria(typeof(Parent)) .SetFetchMode("children", > > FetchMode.Select); > > .CreateCriteria("children").Add(Subqueries.PropertyIn("Id", > > {1,2,3,4})) .List(); > > > Although i have tried setting the fetch mode to lazy load but the > > query still adds all proprties of child class to select list which > > results in duplicate rows. > > > Is there any way I can select all parents without having the child > > details in the select list? > > > How to join a table (Parent) with a secondary table (Child) without > > selecting the second table's columns? > > > I appreciate your help, > > > Thanks > > > Sandra > > > -- > > 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]<nhusers%[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 > athttp://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.
