From HQL to CreateCriteria

SuperMattet · **Joined:** Thu Jul 03, 2008 11:16 am **Posts:** 7

Someone who knows how to translate this HQL-statement to CreateCritera:

The tricky part is to join obs.Art with obs1.Art in the MIN-clause.

from Obs obs where obs.Datum = (select MIN(obs1.Datum) from Obs obs1 where obs.Art = obs1.Art)
ORDER BY obs.Art, obs.Datum, obs.Lopnr

Thanks in advance!

// SuperMattet

wolli · **Posted:** Tue Dec 30, 2008 11:15 am

Try this:

Code:

DetachedCriteria sub = DetachedCriteria.For(typeof(Obs), "obs1")
   .Add(Expression.EqProperty("obs.Art", "obs1.Art"))
   .SetProjection(Projections.Min("obs1.Datum"));

ICriteria crit = session.CreateCritera(typeof(Obs),"obs"))
 .Add(Subqueries.PropertyEq("obs.Datum", sub))
 .AddOrder(....);