i have the following query and its failing in Nhibernate 3 LINQ witha a "Non supported" exception.
My DB tables are:
VacationRequest (id, personId)
VacationRequestDate (id, vacationRequestId)
Person (id, FirstName, LastName)
My Entities are:
VacationRequest (Person, IList)
VacationRequestDate (VacationRequest, Date)
Here is the query that is getting a "Non supported" Exception
Session.Query<VacationRequestDate>().Where(r => people.Contains(r.VacationRequest.Person, new PersonComparer())).Fetch(r=>r.VacationRequest).ToList();
is there a better way to write this that would be supported in Nhibernate?
fyi . .the PersonComparer just compared person.Id
