Getting a list of strings via LINQ

Question

I am trying to get a list of a list of strings in the code below and I am getting an on select that reads:

Cannot implicitly convert type 'System.Data.EnumerableRowCollection>' to 'System.Collections.Generic.List>'

List<List<string>> rows = (from myRow in data.AsEnumerable()
                            select new List<string> {myRow["FirstName"].ToString(),
                                myRow["LastName"].ToString(),
                                myRow["Department"].ToString(),
                                myRow["Birthdate"].ToString(),
                                myRow["Description"].ToString()
                            });

How can I get a list of a list of strings?

Krumelur · Accepted Answer · 2013-08-22 19:58:57Z

5

Linq is working with enumerables (IEnumerable). You need to convert to a list:

List<List<string>> rows = (from myRow in data.AsEnumerable()
                            select new List<string> {myRow["FirstName"].ToString(),
                                myRow["LastName"].ToString(),
                                myRow["Department"].ToString(),
                                myRow["Birthdate"].ToString(),
                                myRow["Description"].ToString()
                            }).ToList();

answered Aug 22, 2013 at 19:58

Krumelur

33.2k28 gold badges140 silver badges288 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1477388 Over a year ago

Thanks this works. I actually tried this, but my stupid VS IDE didn't recognize it. Once I clicked Build, the IDE recognized it.

Krumelur Over a year ago

You're welcome. Even better than "Thanks": Tick the checkmark! :-)

Tim Schmelter · Accepted Answer · 2013-08-22 20:07:10Z

2

Method syntax is more concise:

List<List<string>> rows = data.AsEnumerable()
    .Select(r => r.ItemArray.Select(o => o + "").ToList())
    .ToList();

"half" query syntax:

rows = (from row in data.AsEnumerable()
        select row.ItemArray.Select(o => o + "").ToList())
       .ToList();

edited Aug 22, 2013 at 20:07

answered Aug 22, 2013 at 20:01

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

1 Comment

Krumelur Over a year ago

Shorter yes. But clearer what the result is? Depends. But I like the use of ItemArray.

Collectives™ on Stack Overflow

Getting a list of strings via LINQ

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related