How can i perform this query in NHibernate for getting child count

Question

select name, 
(select count(*) from products where products.category_Id=categories.Id) as productCount
from categories

session.CreateCriteria<Category>()

but whats next?

i don't even know how to search it in Google?

Answer 1

think of your query like

SELECT     categories.Id, count(categories.Id)
FROM         categories inner join products on products.category_Id=categories.Id
group by categories.Id

I think they will produce the same result.

search google for

nhibernate criteria join

and

CreateAlias