Should be something like this:
Code:
DetachedCriteria subquery = DetachedCriteria.For(typeof(Coeff), "c");
subquery.Add( Expression.EqProperty( "c.IdMonth", "cc.IdMonth" ) )
.Add( Expression.EqProperty( "c.IdWork", "cc.IdWork" ) )
.Add( Expression.EqProperty( "c.IdYear", "cc.IdYear" ) )
.Add( Expression.Gt( "Version", Version)
.SetProjection( Projections.Min( "Version" ) );
ICriteria crit = session.CreateCriteria(typeof(Coeff), "cc");
crit.Add( Expression.Eq( "IdWork", id ))
.Add( Subqueries.PropertyGe( "Version", subquery )
I haven't tried it, but I use a similar query in our app.
Regards,
Wolfgang