Could you please post your relevant mapping files and complete sample ICriteria query and finally the sql generated from the ICriteria before it goes to the db.
This may be a bug, but want to confirm before you create a JIRA entry John Davidson On Thu, May 6, 2010 at 4:02 AM, Sandra <[email protected]> wrote: > As I said I have tried it. doesn't seem to work! > > On May 5, 5:35 pm, John Davidson <[email protected]> wrote: > > You can add SetFetchMode on the cars association to Eager in the > ICriteria > > > > John Davidson > > > > > > > > On Wed, May 5, 2010 at 12:27 PM, Sandra <[email protected]> wrote: > > > I did but the values are not loaded. i think it is a buf in nhibernate > > > cos when I set the fetchmode to select, then they shouldnt appear in > > > the select list. > > > > > On May 5, 5:13 pm, John Davidson <[email protected]> wrote: > > > > Then you need to add that as another property in the ProjectionList > > > > > > John Davidson > > > > > > On Wed, May 5, 2010 at 12:04 PM, Sandra <[email protected]> > wrote: > > > > > 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]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > <nhusers%[email protected]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > > > > > <nhusers%[email protected]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > <nhusers%[email protected]<nhusers%[email protected]> > <nhusers%[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]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > <nhusers%[email protected]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[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]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > <nhusers%[email protected]<nhusers%[email protected]> > <nhusers%[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]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[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]<nhusers%[email protected]> > <nhusers%[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]<nhusers%[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]<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 at http://groups.google.com/group/nhusers?hl=en.
