2 Answers
2

The problem is that the select part of your query can't be converted into SQL to be executed on the server (hence the "unrecognised expression node" error). Try something like this, which insures that the necessary code is executed on the client side:

Do you really need to do the string splitting at the server side? Unless you really need to use it in a query, or if it will save a lot of bandwidth to only transfer the first part of the string, I'd fetch it all in the "LINQ to SQL" part and then post-process it with LINQ-to-Objects. Something like this: