SQL语句转成HQL

[vvvsrx]

SELECT a.* FROM ecs_brand a join ecs_goods b on  a.brand_id = b.brand_id group by a.brand_id order by count(*) desc

mysql的语句,如何转成Nhibernate的HQL语句呢....

[vvvsrx]

求高手解答.....

[phil999]

我用过nh，但是冠西楼主的这个sql怎么转我还真蒙了，也许是这样：

from Brand b
order by count(b.Goods) desc

也许