I'm going crazy trying to figure out how to do this:
var annualCount = Convert.ToInt32(
Session.CreateQuery(@"
select count(*) from Activity ta
where ta.Budget = (select top 1 b from ta.Division.Budgets b
where b.ApprovalStatus.Id = 0 order by b.StartDate)"
).UniqueResult());

Is there a way to accomplish this? I'm up for doing it via ICriteria
as well if that works.
thanks

Hi there.

I think you can use IProjection to solve your problem.
Take a look at nhibernate reference.