Linq to Entities: cannot be translated into a store expression
- by FM250
I am trying to execute this query, but I am getting an error: cannot be translated into a store expression.
If I can't do it this way how can I implement it? I am using C#.
I am trying to display training records if the date taken is not this year. Any suggestion is highly appreciated.
tr = from l in t.Trainees
where !db.UserTrainings.Any(ut => ut.Trainees.TraineeId == l.TraineeId &&
ut.Passed == true &&
ut.DateTaken >= l.DateEnded.Value.AddYears(-1))
...... rest of the query.
