R – Doesn’t NHibernate HQL support “with” keyword

hqlnetnhibernate

I'm trying to build a HQL that can left join values from a collection, in order to give me the chance of checking "is null" on it.

Taken from the example from hibernate manual:

from Cat as cat
    left join cat.kittens as kitten
        with kitten.bodyWeight > 10.0

doesn't seem to work in NHibernate, since it doesn't recognize the "with" keyword. How else are you supposed to left join and check for no-matching entries if you cannot specify join-clauses directly in your join as opposed to in your WHERE-statement?

I'm running NHibernate 2.0.0.

Best Answer

Unfortunately, this is not supported in NHibernate. It was first requested in 2005 and is by far the most popular requested feature.

Related Topic