title: LINQ to Entities does not recognize the method 'Char get_Chars(Int32)' method, and this method cannot be translated into a store expression
body: <p>I would like to select only the records that have the field "1" from the string <code>eventTriggers</code> (that looks something like this : "00100010" )</p>
  
  <p>I've tried and succesfully done so with more than 1 calls .. but i doubt its efficient. Basically I would want something like this ... but apprently LINQ does not support this.<br>
  (<code>LINQ to Entities does not recognize the method 'Char get_Chars(Int32)' method, and this method cannot be translated into a store expression.</code>)</p>
  
  <pre><code>     using (var service = new dB.Business.Service.BaseBusinessService&lt;memo&gt;())
     {
        List&lt;memo&gt; result = service.Repository.GetQuery().Where(p =&gt; p.ID == ID &amp;&amp; p.eventTriggers[index] == '1').ToList();
     }
  </code></pre>
  
  <p>Any hints towards the correct solution ? Thank you ! </p>