This question is locked. New answers and comments are not allowed.
I am trying to execute this query:
from i
in
dbContext.Interviews
.Include(r => r.InterviewRooms)
.Where(i =>
(i.InterviewRooms.Any(ir => roomIds.Any(ir.RoomId.ToString().Contains))
|| roomIds.Count == 0)
&&
(dates.Contains(i.WhenCreated.Date)
|| dates.Count() == 0))
orderby i.WhenCreated descending
select i;
but am getting this error:
Failure: Execution of 'System.Linq.Enumerable:Any(IEnumerable`1,Func`2)' on the database server side currently not implemented.
The purpose of the line with the .Any() is to find if a list contains any elements present in a second list (check the RoomId of each InterviewRoom to see if it is contained in a list of wanted roomIds).
How should I be writing that query so that DataAccess likes it?
Thanks!!