title: LINQ to Entities does not recognize the method '<>f__AnonymousType4`1[System.String] get_Item(Int32)'
body: <p>please I'm working on a ASP.NET MVC project with Entity Framework, I try to use this Query but I got an error .</p>
  <p><strong>Query :</strong></p>
  <pre><code>var R = (from A in SCHOOL_DB_Context.Con.ABS where A.STG_ABS == STG &amp;&amp; (A.DT_ABS.Month + &quot;/&quot; + A.DT_ABS.Year) == MONTHS[i].MONTH &amp;&amp; A.DT_ABS.Hour == Hour select A).ToList();
  </code></pre>
  <p><strong>Error :</strong></p>
  <blockquote>
  <p>LINQ to Entities does not recognize the method
  '&lt;&gt;f__AnonymousType4`1[System.String] get_Item(Int32)' method, and
  this method cannot be translated into a store expression.</p>
  </blockquote>
  <p><strong>The full code is :</strong></p>
  <pre><code>    var MONTHS = (from A in SCHOOL_DB_Context.Con.ABS where A.STG_ABS == STG &amp;&amp; A.DT_ABS.Hour == Hour group A by A.DT_ABS.Month + &quot;/&quot; + A.DT_ABS.Year into G select new { MONTH = G.Key }).ToList();
  
      List&lt;DataPoint&gt; DATA = new List&lt;DataPoint&gt;();
  
      List&lt;DataPoint&gt; DTP = new List&lt;DataPoint&gt;();
  
      if (MONTHS.Count == 0)
      {
  
          DTP.Add(new DataPoint(null, null));
  
      }
      else
      {
  
          for (int i = 0; i &lt; MONTHS.Count; i++)
          {
  
              var R = (from A in SCHOOL_DB_Context.Con.ABS where A.STG_ABS == STG &amp;&amp; (A.DT_ABS.Month + &quot;/&quot; + A.DT_ABS.Year) == MONTHS[i].MONTH &amp;&amp; A.DT_ABS.Hour == Hour select A).ToList();
  
              int Count = 0;
  
              Count = R.Count;
  
  
              //DATA.Add(new DataPoint(MONTHS[i].MONTH, Count));
  
  
  
              DTP.Add(new DataPoint(MONTHS[i].MONTH, Count));
  
          }
  
      }
  </code></pre>
  <p>Please any help to fix this issue?</p>