LINQ to Entities does not recognize the method 'System.Guid get_Item(Int32)' method, and this method cannot be translated into a store expression.

This error is telling you not to fish something out of a list or array midstream in the LINQ mechanics. Pull that item out to a variable upstream first.