Ok I found it. This feature came with NH 3.0 alpha 2 2010/9/17 Armin Landscheidt <[email protected]>
> This was what I'm looking for but in which version? NH 2.1 has no signature > like this. > > 2010/9/17 Fabio Maulo <[email protected]> > > NHibernate has 6 ways to query your domain btw >> >> ICriteria CreateCriteria(string associationPath, string alias, JoinType >> joinType, ICriterion withClause); >> >> >> On Thu, Sep 16, 2010 at 9:22 AM, harshil hameed <[email protected]>wrote: >> >>> firiends.., pls help us on it,. >>> >>> If 'Criteria' api not support this,we will go with HQL. >>> >>> but like to go with 'Criteria' api always,,(nt hql ;( ) >>> >>> >>> >>> >>> On Thu, Sep 16, 2010 at 5:35 PM, Jason Meckley >>> <[email protected]>wrote: >>> >>>> Oh sorry, misunderstood the problem. that's a good question, I'm not >>>> sure if/how that's possible. >>>> >>>> On Sep 15, 5:53 pm, Armin Landscheidt <[email protected]> wrote: >>>> > em yes this is the reason why I want use the Criteria api ;-). The >>>> > question is not how to use the api, it's how to add conditions to a >>>> > join? In hql you can do this with the "with" keyword as Fabio >>>> > mentioned but there is no equivalent in the criteria api. >>>> > >>>> > On Sep 15, 11:08 pm, Jason Meckley <[email protected]> wrote: >>>> > >>>> > > Criteria is meant to build queries at run-time (dynamically). HQL is >>>> > > meant for design-time queries. trying to build an HQL statement at >>>> > > runtime is counter intuitive. >>>> > >>>> > > var criteria = session.CreateCriteria<Entity>(); >>>> > > if(....) >>>> > > { >>>> > > criteria.Add(....);} >>>> > >>>> > > //repeat as necessary >>>> > >>>> > > var results = criteria.List<Entity>(); >>>> > >>>> > > On Sep 15, 4:59 pm, Armin Landscheidt <[email protected]> >>>> wrote: >>>> > >>>> > > > Is there a way to do this with the Criteria API? In my project I'm >>>> > > > building a dynamic query an using HQL at this point is a pain. >>>> > >>>> > > > On Sep 13, 3:07 pm, harshil hameed <[email protected]> wrote: >>>> > >>>> > > > > can we do same with out HQL, >>>> > > > > (//like wise Criteria.CreateAlias,) >>>> > > > > we are not recommend HQL any where in Product. >>>> > >>>> > > > > On Mon, Sep 13, 2010 at 5:28 PM, Fabio Maulo < >>>> [email protected]> wrote: >>>> > > > > > the clause is : "with" >>>> > > > > > >>>> http://fabiomaulo.blogspot.com/2009/05/nhibernate-210-hql-with-clause. >>>> .. >>>> > >>>> > > > > > On Mon, Sep 13, 2010 at 8:23 AM, Armin Landscheidt < >>>> [email protected] >>>> > > > > > > wrote: >>>> > >>>> > > > > >> Hello, >>>> > >>>> > > > > >> I have a little performance problem and could resolve it if I >>>> could >>>> > > > > >> add the restriction in the where clause to the join clause. >>>> Actual the >>>> > > > > >> generated sql looks like: >>>> > >>>> > > > > >> select * from parent p >>>> > > > > >> left outer join child c on c.Parent = p.Id >>>> > > > > >> where p.Name like '%theName%' or c.Name like '%theName%' >>>> > >>>> > > > > >> This is to slow. But if I could generate a statement like >>>> > >>>> > > > > >> select * from parent p >>>> > > > > >> left outer join child c on c.Parent = p.Id and c.Name like >>>> '%theName%' >>>> > > > > >> where p.Name like '%theName%' >>>> > >>>> > > > > >> it would be much faster. >>>> > >>>> > > > > >> Is there a way to realize this? >>>> > >>>> > > > > >> Regards Armin >>>> > >>>> > > > > >> -- >>>> > > > > >> 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. >>>> > >>>> > > > > > -- >>>> > > > > > 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]<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 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 at >>> http://groups.google.com/group/nhusers?hl=en. >>> >> >> >> >> -- >> 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]<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.
