How can we arrange a column as int using the sleep API parameters?

Question

Hi, I want to get a data form database using the sleep API.

This data should be sorted by column as number.

This column is defined as varchar in the database. But I have to get the number.

I ran into a problem using the criteria API, as it arranges as a string onlyly.

Example: I get data like

9, 8, 7, 6, 5, 4, 3, 2, 1,10

but I want the data to be

10,9,8,7,6,5,4,3,2,1

Are there any Hibernate methods for hidden varchar for a number, for example convert ("some column", int) or cast ("some column", int)?

+2

Satya May 20, '10 at 5:03

1 answer

dotjoe · Accepted Answer · 2010-05-20T17:51:40+0000

Projections.Cast() cast(column as type).

.AddOrder(Projections.Cast(NHibernateUtil.Int32, Projections.Property("stringColumn"))