Return properties from subclass left joins when querying superclass in NHibernate?

Var results = session.CreateCriteria() .List() . Select(a => new { Id = a. Id, Name = a.Name, Wingspan = (a is Bird)?

((Bird)a). Wingspan : (int)null }).

I forgot to mention in the question, but I need to be able to sort and filter on the Wingspan property and page the results. – Annabelle Nov 10 at 19:21 then there is no easy way I think. You can use DetachedCriteria or Expression.

Sql("NHgeneratedAlias. Wingspan 10") and Order. Asc(Projections.

SqlProjection("NHgeneratedAlias. Wingspan")); – Firo Nov 11 at 8:51.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.