My goal is to invoke coalesce operator in select statement "order by"
clause using NHibernate Criteria API.
Does the API support coalesce function? Reason being I tried the
following snippet but it did not yield the desired results. In fact I
could not see the coalesce operator in the resulting sql using
NHibernate profiler.
var projectionList = Projections.ProjectionList();
projectionList.Add(Projections.Property("Column1"));
projectionList.Add(Projections.Property("Column2"));
var result = Projections.SqlFunction("coalesce",
NHibernateUtil.String, projectionList);
I am performing a complex join involving over 7 tables and I am
interested in sorting the result set by 2 columns (one of which could
be null; hence the coalesce)
I'd seen a lot of examples on which involves invoking SQL functions
such as Year, Month etc but not with coalesce.
Any pointers on how to go about with it?
--
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.