Linq to Entities: cannot be translated into a store expression
<p>I am trying to execute this query, but I am getting an error: cannot be translated into a store expression.</p>

<p>If I can't do it this way how can I implement it? I am using C#. </p>

<p>I am trying to display training records if the date taken is not this year. Any suggestion is highly appreciated. </p>

<pre><code>tr =  from l in t.Trainees
      where !db.UserTrainings.Any(ut =&gt; ut.Trainees.TraineeId == l.TraineeId &amp;&amp;
                                        ut.Passed == true &amp;&amp;
                                        ut.DateTaken &gt;= l.DateEnded.Value.AddYears(-1)) 
      ...... rest of the query.
</code></pre>
