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]>
> > >> .
> > >> 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.
