have sql's "table" variable in nHibernate?

mingzaili · **Joined:** Mon Nov 21, 2005 6:30 am **Posts:** 2

in sql:
SELECT TOP 10 * FROM (SELECT TOP 10 * FROM (SELECT TOP 10 * FROM 客户 ORDER BY 序号) AS TABLE1 ORDER BY 序号 DESC) AS TABLE2 ORDER BY 序号

in nHibernate? How write?

thank you very much!!

KPixel · **Posted:** Sat Nov 26, 2005 9:02 am

HQL is similar to SQL, so you may try to write your query progressivily and see what you get.

NHibernate Query Analyzer might help you :wink:
http://www.ayende.com/projects/nhibernate-query-analyzer.aspx