why doesnt' nhibernate support this "exists in list" syntax ??
- by ooo
i have the following query and its failing in Nhibernate 3 LINQ witha a "Non supported" exception. Its similar to this question but this question was asked over a year ago so i am positive that the answer is out of date.
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
