With a SQL Query I can order by N, where N is a column index. For example
SELECT name, salary FROM employee ORDER BY 2;
How can I do this with nHibernate?
views:
52answers:
1
A:
You can't. NHibernate order by clause requires property names (aliases) and / or expressions to be specified.
ChssPly76
2009-10-27 19:52:25
so I need fluent hibernate? (not that I know what that is)
Dead account
2009-10-27 19:57:34
Fluent NHibernate is just a way to declare mappings for your entities without resorting to XML; it has nothing to do with HQL's `order by`. You cannot (nor should you as `rexem` rightly pointed out above) order by ordinals in HQL.
ChssPly76
2009-10-27 20:07:18