Hi all,

I need the ability to sort data using a random sort order, I already have an 
implementation as the following:

public class RandomOrder : Order
{
                public RandomOrder()
                               : base( "", true )
                {

                }

                public override SqlString ToSqlString( ICriteria criteria, 
ICriteriaQuery criteriaQuery )
                {
                               return new SqlString( "newid()" );
                }
}

And it works as expected, but obviously works only for Sql Server, how can I 
build something that integrates with the dialect and can be used using all NH 
query systems (ICriteria, hql, QueryOver, etc...)?

We are currently using NHibernate 3.1.0.4000

Cheers
.m

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to