This query is working:

           RegisterFragment(CONSUMER_BY_USED_MYBRAND_FIRST, x => x.OrderBy(
                            Projections.Conditional(
                            Restrictions.Where<VehicleListing>(v => 
v.Manufacturer == "My Brand"),
                            Projections.Constant(0),
                            Projections.Constant(1))).Asc.
                            ThenBy(y => y.Condition).Desc.
                            ThenBy(y => y.Id).Asc);

It sorts the list of results and puts "My Brand" first, followed by non "My 
Brand" cars, while both sets follow the subsequent ThenBy() conditions.

BUT, I now need to only include this OrderBy condition based on the look-up 
results of a distinct join.

How can I modify this query to handle that?

Thanks!

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.

Reply via email to