When using the entity framework you may come across an error message such as this:
“LINQ to Entities does not recognize the method ‘get_Item(Int32)’ method, and this method cannot be translated into a store expression.”
After doing some research the root cause of this issue was that in Linq I was trying to resolve a GUID and then using that as part of the Select statement. In order to avoid this I just had to resolve the GUID in a previous command line and assign it to a a new variable. I then used that variable in the select statement and it worked fine.
You can see an example here.