title: The 'ArrayIndex' LINQ expression node type is not supported by LINQ to Entities - using interface & ReportViewer
body: <p>a quick question really.<br>
  I'm struggling to implement Linq2Entities statement that could take more than one value for a particular "field". I'm passing a number of strings to the <code>getClientsProjected()</code> I can easily compare single value. But I've got on my page multiple dropdown and out of that I get string separated with coma I then later use to split it to <code>string[]</code> e.g. <code>__ACCOUNT_SITE = "1234,5678"</code> (see the code below) I've tried for/foreach/contains none of which worked...</p>
  
    
  
  <pre class="lang-or-tag-here prettyprint-override"><code>public IQueryable&lt;ClientViewModel&gt; getClientsProjected(string __ACCOUNT_SITE, string __ACCOUNT)
  {
      var projectedClients = from c in getClosedSRs()
                             select new ClientViewModel
                             {
                                 _ACCOUNT_ID_CSR = c.ACCOUNT_ID_CSR,
                                 _ACCOUNT = c.ACCOUNT,
                                 _ACCOUNT_FAMILY = c.ACCOUNT_FAMILY,
                                 ...
                                 ...
                                 _ACCOUNT_SITE = c.ACCOUNT_SITE
                             };
  
      if (String.IsNullOrEmpty(__ACCOUNT) != true &amp;&amp; __ACCOUNT != "ALL")
      {
          //this works fine as an __ACCOUNT is of a single value
          projectedClients = projectedClients.Where(c =&gt; c._ACCOUNT == __ACCOUNT);
      }
  
      if (String.IsNullOrEmpty(__ACCOUNT_SITE) != true &amp;&amp; __ACCOUNT_SITE != "ALL")
      {
          String[] splitSites = __ACCOUNT_SITE.Split(',');
          //????????????????????????????????????????????????
      }
      return projectedClients;
  }
  </code></pre>
  
  <p>Now, to most of you this will make complete sense. I've read many articles but did not find a proper answer. I however can't use Linq2SQL as already built my entire site using L2E, interface and ReportViewer. </p>
  
  <p>Any workaround?</p>