resolved.
----------------
Hi all,
I'm having difficulty ordering distinct results. For this problem I need to get distinct album objects based on genre.name value. In order to do this I need to go from Album -> Tracks ->Genre and I need the reults ordered by Album.Artist.name. The query below works fine but it doesn't order the required Album.Artist.Name as I expect it to.
Code:
ICriteria criteria = session.CreateCriteria(typeof(Album))
.CreateAlias("Artist", "ar")
.AddOrder(Order.Desc("ar.Name"))
.CreateCriteria("Tracks")
.CreateCriteria("Genre")
.Add(Expression.Eq("Name", genre))
.SetResultTransformer(CriteriaUtil.DistinctRootEntity);
Login
FAQ
Search