Select Random Records Using Nhibernate

Selecting 5 random rows in SQL is easy

Nhibernate is a different story.  I am new to NHibernate and I both love and hate it.  I hate the steep learning curve and the unobvious ways of doing things.  Anyway, here is how to select 5 random records using nhibernate.

First class a new order class to perform random ordering:

Then use the new class in your query:

Done…