ansaurus

Question

Answer 1

A:

Sure:

session.CreateQuery(@"
        select distinct a
        from A a
        join a.Bs b
        where b.b = 'bla'
        ").List<A>();

If the relationship is bidirectional (i.e. B has a reference to A), it's even easier:

select distinct b.A
from B b
where b.b = 'bla'

I assumed you meant B.b equals 'bla'. If you meant bla is part of B.b, you can use the LIKE operator just like in SQL

Diego Mijelshon 2010-10-06 13:06:28

Thanks. SQL and HQL is ok but I was wondering how to do this with ICriteria. I suppose I have to create some alias like list.b ???

csetzkorn 2010-10-06 13:18:14

I really don't remember how to do it with Criteria. But why do you need that?

Diego Mijelshon 2010-10-06 14:07:19

I am using some existing stuff which has, for example, a method like this: ICriteria GetPagedCriteria<T>(PagedRequest request, bool sort)

csetzkorn 2010-10-07 11:48:48

You're unnecessarily limiting yourself. Take a look at http://code.google.com/p/unhaddins/source/browse/#hg/uNhAddIns/uNhAddIns/Pagination

Diego Mijelshon 2010-10-07 13:36:57

ICriteria query - finding objects whith certain properties in their lists