This query returns an IList<Price>, how about returning an IList<AbstractProduct> ?
On Jul 7, 4:46 pm, Tuna Toksoz <[email protected]> wrote: > select pr.AbstractProduct from Price pr where pr.Quantity = 1 and > (pr.Expires > :expire or pr.Expires is null) order by pr.Amount > > This HQL? > yes. > > Gmail code > > var criteria=session.CreateCriteria(typeof(Price),"pr") > .Add(Restrictions.Eq("pr.Quantity",1)) > .Add( > Restrictions.Or( > > Restrictions.Gt("pr.Expires",theDate), > > Restrictions.IsNull("pr.Expires"))) > .AddOrder(Order.Asc("pr.Amount")) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
