That will not work on 1.2, only on 2.0
On Mon, Sep 29, 2008 at 5:10 PM, givoni <[EMAIL PROTECTED]> wrote:
>
> Hi Thomas,
>
> Thanks for your quick reply.
>
> The 2nd and 3rd steps are the ones I don't know how to implement :)
>
> My code looks like this:
> DetachedCriteria pointsAmount = DetachedCriteria.For(typeof(Points),
> "pointsAmount")
> .SetProjection(Projections.Sum("Amount"))
> .Add(Property.ForName("User.Id").EqProperty("U.Id"))
> .Add(Expression.Ge("CreateTime", fromDate))
> .Add(Expression.Le("CreateTime", toDate));
>
> ICriteria criteria = session.CreateCriteria(typeof(User), "U");
> criteria.Add(Expression.Eq("U.Activated", true));
> criteria.Add(Subqueries.Gt(0, pointsAmount));
>
> How would you add pointsAmount to the order clause?
>
> Thanks,
> David
>
> On Sep 29, 4:02 pm, Thomas Koch <[EMAIL PROTECTED]> wrote:
> > Hi David - I am not sure that I fully understand your question, but
> > with NH 2.0 I have done the following:
> >
> > 1) Create the sub-query as a detached query.
> > 2) Apply the detached query to the "main" criteria, using one of the
> > static methods in the SubQueries class.
> > 3) Apply ordering to the main criteria, using the AddOrder method of
> > the ICriteria interface.
> > 4) Execute the criteria.
> >
> > Hope this helps, otherwise please give a bit more detail. :-)
> >
> > Cheers,
> > Thomas
> >
> > On 29 Sep., 15:49, givoni <[EMAIL PROTECTED]> wrote:
> >
> > > Hi,
> >
> > > I'm using nhibernate 1.2 and I can't seem to find a way to order by a
> > > subquery using icriteria.
> > > Is this possible?
> >
> > > Regards,
> > > David
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
