C# – How to Determine the Sort Order of an NHibernate ICriteria Object

cicriterianhibernate

What is the best way to retrieve the list of Orders added to an ICriteria object using the AddOrder method? I believe this will have to be accomplished using Reflection, but what to reflect on?

The purpose of doing this is that I would like to pass the sort order back to the UI so an indication of the sort order can be provided to the user.

Best Answer

var impl = session.CreateCriteria<User>().AddOrder(Order.Asc("Id")) as CriteriaImpl;

foreach (CriteriaImpl.OrderEntry entry in impl.IterateOrderings())
{
Order order = entry.Order;
    // now you have the order and you can either parse it : "propertyName asc" 
                                                         or "propertyName desc"
    // or you can check it out in debug, it has a few protected fields that you could reflect. 
    // not sure if there's another way.
}

Related Solutions

C# – How to sort a dictionary by value

Use LINQ:

Dictionary<string, int> myDict = new Dictionary<string, int>();
myDict.Add("one", 1);
myDict.Add("four", 4);
myDict.Add("two", 2);
myDict.Add("three", 3);

var sortedDict = from entry in myDict orderby entry.Value ascending select entry;

This would also allow for great flexibility in that you can select the top 10, 20 10%, etc. Or if you are using your word frequency index for type-ahead, you could also include StartsWith clause as well.

R – Is it possible to get a lazy IEnumerable from an NHibernate query using ICriteria

ICriteria doesn't have any methods that return an IEnumerable, but IQuery does.

Best Answer

Related Solutions

C# – How to sort a dictionary by value

R – Is it possible to get a lazy IEnumerable from an NHibernate query using ICriteria

Related Topic