Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

3
  • In which line the error occurs? I think the problem is related to your join query when assigning result. Commented Nov 11, 2016 at 1:09
  • yes, that's correct the error is while assigning result..i am not able to figure it out.. Commented Nov 11, 2016 at 1:52
  • You're attempting to join a database object with collections stored in memory which throws NotSupportedException. Try remove ToList() method from userNames declaration before Select statement, since EF can only referred to join if the IEnumerable type parameter is any primitive types (e.g. int), but you can use IQueryable to do so. Commented Nov 11, 2016 at 1:59