Is there a LINQ equivalent of string.Join(string, string[]) [duplicate]

Question

Is there any way to convert a collection of objects into a single new object using LINQ?

I want to use this within another LINQ to SQL expression.

Answer 1

Why don't you use the string.Join itself?

string.Join("<br/>", collection.Select(e => e.TextProp).ToArray());

Answer 2

You can use the Aggregate method...

var myResults = (from myString in MyStrings
                 select myString)
                .Aggregate(string.Empty, (results, nextString) 
                   => string.Format("{0}<br />{1}", results, nextString));

or

var myResults = MyStrings.Aggregate(string.Empty, (results, nextString) 
                   => string.Format("{0}<br />{1}", results, nextString));