Linq query DateTime.Date.DayOfWeek
<p>Trying to get only Thursdays of 1 year back</p>

<pre><code>using (var context = new Context1())
{
      // Get 1 year back only Thursday
      var oneYearEarlier = DateTime.Now.AddYears(-1);

      var query = (from c in context.Daily25Data
                   where c.Date &gt; oneYearEarlier &amp;&amp; c.Date.DayOfWeek == DayOfWeek.Thursday
                   select c).ToList();

      Console.WriteLine(query);
}
</code></pre>

<p>and getting</p>

<blockquote>
  <p>Additional information: The specified type member 'DayOfWeek' is not
  supported in LINQ to Entities. Only initializers, entity members, and
  entity navigation properties are supported.</p>
</blockquote>