Note: This article was originally published in 2010. Some steps, commands, or software versions may have changed. Check the current .Net documentation for the latest information.
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 (http://www.xtremedotnettalk.com/showthread.php?p=469218).