Querying Overriding Entities Using a Self Join and the NHibernate Criteria API?

I ended up brute forcing a solution. It's not pretty, but since I know the table will be tiny (probably going to end up being only 5 rows) I came up with the following code solution.

I ended up brute forcing a solution. It's not pretty, but since I know the table will be tiny (probably going to end up being only 5 rows) I came up with the following code solution: public IList GetLatest() { using (var session = SessionManager.OpenSession()) { var criteria = session. CreateCriteria(typeof (Waiver)); var waivers = criteria.List(); var nonOverridenWaivers = new List(); foreach(var waiver in waivers) { bool overrideExists = waivers.

Any(w => w. Overrides! = null && w.Overrides.Id == waiver.

Id); if (!overrideExists) nonOverridenWaivers. Add(waiver); } return nonOverridenWaivers; } }.

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.