If I have base class and 2 classes that inherit form that, then how to write a query on property which is defined differently in both inheritors?

Example :

class vehicle
{

}


class Bus : vehicle
{
public BusType busType;
}

class Car : vehicle
{
public int NumberOfWheels;
}

class BusType
{
public int NumberOfWheels;
}


Now, if I want to create subquery to find vehicles by number of wheels, how would it be ?
I never know if I have Bus or Car thats why I have mapped base class(vehicle).

NB! I am using Criteria API to create queries.

Thanks!

More basic, how to create subcriteria on mapped class inheritors property?

Why can;t you pull the NumberOfWheels property up to the Vehicle superclass? Then you can just .Add(Expression.Eq("NumberOfWheels",2)) for a DetachedCriteria.For(typeof(Vehicle)) ?
If you want to restrict it to either Bus or Car, you'd simply make the DetachedCriteria.For(typeof(Bus)).

Mike

Unfortunately this is not solution for me.

No idea, anybody ?

You could use a CreateSQLQuery for that

"
SELECT Id FROM Bus JOIN BusType ON BusType.busId = Bus.busTypeId WHERE NumberOfWheels = 2

UNION

SELECT Id FROM Car WHERE NumberOfWheels = 2
"

Henrique

ps: I hope it's not too late