I couldn't find anything anywhere so I assume this is not possible but anyhow.

Does anyone know of a way to specify the default ORDER BY column for a class in its mapping file?

*edit*
whoops, forgot to mention -> NHibernate 2.01 and MSSQL 2000 & 2005


The thing I would want to achieve is that if no ordering is used in the application, the query should be ordered by its primary key column(s) automatically.
In MSSQLits not guaranteed that the order is consistent if no ORDER BY clause is used in the query so I wanted to have some automatic way to make sure I at least have some consistent order that doesn't pose a performance bottleneck.

If that's not possible I may have to do some tweaking in the DAO classes but maybe this works in the .hbm files already.



Greets
mosi

I'm not sure if this helps, but part of the following link discusses how to specify the order-by clause in your mapping file (See Section 6.2 of the following):

http://www.hibernate.org/hib_docs/nhibernate/html/collections.html

Its not exactly what I had in mind but thanks for the hint, maybe I'll can use that someplace else.

the ordering that I wanted to have was for something like a simple query, not a relation like a bag or the likes. In SQL the query would read like



no order is requested in the above query so nhibernate should append an order by id for this case.



Maybe there is a way to tell NHibernate to do this in the mapping files.