Thanks for suggestion, however this is purley a client side fix (client side being web server) and not a SQL fix. If I introduce paging etc then this does not have effect I am looking for. I personally use a sub query but looking for a optimum way (if there is such a thing) whilst keeping to all the goodness QueryOver provides.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Groch Sent: 28 July 2011 12:49 To: nhusers Subject: [nhusers] Re: Use the DISTINCT keyword when using QueryOver Try it: return Session .QueryOver<Movie>() <-- I want distinct Movies .Inner.JoinQueryOver<Actor>(a => a.ActorList) .Where(a => a.Name.IsLike("m%")) .TransformUsing(Transformers.DistinctRootEntity) .List(); On Jul 28, 11:51 am, "Richard Wilde" <[email protected]> wrote: > Is it possible to introduce a DISTINCT keyword into the generated SQL using > QueryOver. > > return Session > > .QueryOver<Movie>() <-- I want distinct Movies > > .Inner.JoinQueryOver<Actor>(a => a.ActorList) > > .Where(a => a.Name.IsLike("m%")) > > .List(); > > I suppose I am looking for something like .QueryOverDistinct<Movie>() ... > > If I use Projection.Distinct and project into a DTO I lose the ability to > lazy load. What are my options? > > Or do I have to fall back to HQL or use a sub query? > > Thanks > > Rippo -- 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. -- 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.
