Linq to NHibernate OrderBy Enum value

Question

I have the following Enum which describes the status of an item and an object that represents the item. ``` public Enum Status { Sent, Received, UnderWork, Returned } public Class Item { public virtual int Id {get;set;} public virtual Status CurrentStatus {get;set;} public virtual string ItemDescription {get;set;} public virtual int ItemNumber {get;set;} public virtual DateTime DueDate {get;set;} } ``` I need to create a query where I can select a number of Items and order them first by the CurrentStatus property and secondly by the DueDate property. The difficulty is I want to order by the CurrentStatus by placing all Items with a Returned Status last while ordered by their DueDate and then order all other Items only by DueDate and ignoring the CurrentStatus. So the following list of data: ``` ID | CurrentStatus | ItemDescription | ItemNumber | DueDate ------------------------------------------------------------- 1 | Returned | Description1 | 123456 | 16/01/2012 2 | Sent | Descriptio…

Accepted Answer

This worked for me. It's more explicit in how NHibernate should handle the status and generate the SQL `case` statement

```
var workList = session.Query<Item>()
    .OrderBy(item => item.CurrentStatus == Status.Returned ? 1 : 0)
    .ThenBy(item => item.DueDate)
    .ToList();
```

Linq to NHibernate OrderBy Enum value

Solution

Problem