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 :)

Answer 1

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

Answer 2

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 + ")"));