title: The LINQ expression node type 'ArrayIndex' is not supported in LINQ to Entities
body: <pre><code> var residenceRep = 
       ctx.ShiftEmployees
          .Include(s =&gt; s.UserData.NAME)
          .Include(s =&gt; s.ResidenceShift.shiftName)
          .Join(ctx.calc,
                sh =&gt; new { sh.empNum, sh.dayDate },
                o =&gt; new { empNum = o.emp_num, dayDate = o.trans_date },
                (sh, o) =&gt; new { sh, o })
          .Where(s =&gt; s.sh.recordId == recordId &amp;&amp; s.o.day_flag.Contains("R1"))
          .OrderBy(r =&gt; r.sh.dayDate)
          .Select(r =&gt; new
               {
                    dayDate = r.sh.dayDate,
                    empNum = r.sh.empNum,
                    empName = r.sh.UserData.NAME,
                    shiftId = r.sh.shiftId,
                    shiftName = r.sh.ResidenceShift.shiftName,
                    recordId,
                    dayState = r.o.day_desc.Split('[', ']')[1]
               }).ToList();
  </code></pre>
  
  <hr>
  
  <p>I get an exception :</p>
  
  <blockquote>
    <p>The LINQ expression node type 'ArrayIndex' is not supported in LINQ to
    Entities</p>
  </blockquote>
  
  <p>How i could find an alternative to <code>Split('[', ']')[1]</code> in this query</p>