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