Linq to Sql SelectMany

Question

I am trying to understand the to Sql SelectMany. I want to use it in the query below to see how the results are generated using SelectMany as against Select. I know I can just use a select here instead...I have a table users with Id as int and location as a string. When I run the query below I get the exception "Sequence Operators not supported for type System.String". Can you please tell me how do I iterate the results that are returned by SelectMany and print the results to console.

UsersDataContext db = new UsersDataContext(); var results = db.Users.Where(u=> u.ID == 5 || u.ID == 6).SelectMany(u => u.Location); foreach (var c in results) { Console.WriteLine(c); }

undefined · Accepted Answer · 2012-07-16 02:46:48Z

You should use .Select here.

From MSDN on SelectMany:

Projects each element of a sequence to an IEnumerable and flattens the resulting sequences into one sequence.

Basically SelectMany works on taking a lambda pointing to a collection and then flattening it into a single resultset. Location in your example isnt a collection

Collectives™ on Stack Overflow

Linq to Sql SelectMany

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related