Using linq to build a comma delimited string

Question

I need to generate a string that has a comma delimited list, but no comma after the last element.

var x = new List<string>() { "a", "b", "c" };

should yield:

a,b,c

Yes, a very simple thing to do using "normal" techniques, but I hope with linq there is a more elegant way.

var cols =context.Database.SqlQuery<String>("select Column_Name from INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = {0};", prefix + table);

Use String.Join to concatenate list items with coma String.Join(",", x) — Sergey Berezovskiy
– Sergey Berezovskiy, Commented Jan 27, 2014 at 17:39
not sure what the last line is but you need to be careful about where prefix and table come from. — Jodrell
– Jodrell, Commented Jan 27, 2014 at 17:44

Siva Charan · Accepted Answer · 2014-01-27 17:40:05Z

2

No need Linq, just use String.Join

String.Join(",", new List<string>() { "a", "b", "c" });

answered Jan 27, 2014 at 17:40

Siva Charan

18.1k10 gold badges64 silver badges95 bronze badges

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

Comments

Jignesh Thakker · Accepted Answer · 2014-01-27 17:43:34Z

0

String class provide Join method to join string array with delimiter.

Code:

var x = new List<string>() { "a", "b", "c" };
String.Join(",",x.ToArray());

answered Jan 27, 2014 at 17:43

Jignesh Thakker

3,7082 gold badges31 silver badges35 bronze badges

Abbas · Accepted Answer · 2014-01-27 17:44:03Z

0

Although I strongly recommend you use the answer of Siva Charan, just for information here's an implementation in LinQ using Enumerable.Aggregate Method (IEnumerable, Func):

var result = x.Aggregate((c, n) => c + "," + n);

answered Jan 27, 2014 at 17:44

Abbas

14.5k6 gold badges43 silver badges77 bronze badges