lambda list to combine string

Question

Here is my table ,

myTable
-------------
id      name       age
-------------------------
1     NameOne       10
2     NameTwo       11
3     NameThree     12
4     NameFour      13  
5     NameFive      14

I retrieve my table likes ,

var _myList = DBContext.myTables.ToList();

I want to get string likes

"NameOne,NameTwo,NameThree,NameFour,NameFive"

How can I do this in shorter way ?

Andrei · Accepted Answer · 2013-07-02 08:10:25Z

33

Use String.Join

string names = String.Join(",", _myList.Select(x => x.Name));

Or you can even avoid loading other columns from DB:

string names = String.Join(",", DBContext.myTables.Select(x => x.Name));

answered Jul 2, 2013 at 8:10

Andrei

56.8k10 gold badges92 silver badges114 bronze badges

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

Comments

Jon Skeet · Accepted Answer · 2013-07-02 08:10:56Z

10

It sounds like you want:

string names = string.Join(",", DBContext.myTable.Select(x => x.Name));

You don't need to go through an intermediate list - and in fact it's more efficient not to. With this query, only the names will be fetched from the database.

answered Jul 2, 2013 at 8:10

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

5 Comments

bazz Over a year ago

May I dare to correct one small mistake (big fan of Jon) :), you need to convert it into an Array, because string.Join expects a string array.

Andrei Over a year ago

@bazz, actually there is an overload that accepts IEnumerable.

Jon Skeet Over a year ago

@bazz: It depends on the version of .NET you're using. The overload list was significantly expanded in .NET 4.

bazz Over a year ago

@Andrei Really? Can you point me to some reference? MSDN

Jon Skeet Over a year ago

@bazz: Look at the documentation you're pointing to - on the left side of the screen there's an overload list...

Darin Dimitrov · Accepted Answer · 2013-07-02 08:10:40Z

0

var _myList = DBContext.myTables.ToList();
var names = _myList.Select(x => x.name);
var formattedStrings = string.Join(", ", names);

answered Jul 2, 2013 at 8:10

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

Collectives™ on Stack Overflow

lambda list to combine string

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related