Lambda expression select and combine fields as single string

Question

Let's say , I have tableOne as this structure

Name            Age
=========================
John            34
Ammy            23
Joe             16
Sam             18

What I want to get is likes this format in a single string

John (34) , Ammy (23) , Joe (16) , Sam (18)

How can I get this in a short way using lambda expression ? Thanks :)

What have I tried ? Just select as a List Siva :) tableOne.ToList() — zey
– zey, Commented Jul 30, 2013 at 6:12
@zey I think what Siva means is, what have you tried to do to produce a string like that? Even if your attempt didn't work or didn't even compile, at least it shows that you tried something. People on SO are generally forgiving of bad code, but we usually want to see some code :P — p.s.w.g
– p.s.w.g, Commented Jul 30, 2013 at 6:21

Damith · Accepted Answer · 2013-07-30 06:11:10Z

8

var result = string.Join(",", tableOne.Select(x=>string.Format("{0} ({1})", x.Name, x.Age)));

answered Jul 30, 2013 at 6:11

Damith

63.2k13 gold badges106 silver badges154 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 10:29:56Z

4

Damith's answer is excellent, and actually cleaner, but if you need to use this with entity framework or some other ORM, you'd probably have to do something like this:

var result = String.Join(" , ", 
    tableOne.Select(x => x.Name + " (" + x.Age + ")"));

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Jul 30, 2013 at 6:11

p.s.w.g

150k31 gold badges307 silver badges339 bronze badges

1 Comment

Sergey Berezovskiy Over a year ago

BTW you don't need to call ToString() on integer when concatenating it with string

Collectives™ on Stack Overflow

Lambda expression select and combine fields as single string

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related