tags:

views:

119

answers:

0

Hi!

Normally I'm using criteria api to make queries against my database, but because criteria api seems to have a bug when searching for the same entity twice, I would like to append a custom piece of HQL to the rest of my criteria. Is this somehow possible?

Here is an example of what is not working with criteria api:

public class Person
{
    public IList<Room> Rooms { get; set; }
}

public class Room
{
    public string Name { get; set; }
}

I would like to search for all persons that have a room with name 'Room A' and another with name 'Room B'.

Best Regards
Oliver Hanappi