I need a LINQ query that formats my XML data as CSV data [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

The xml is the below format :

<categories>
  <category>Find product</category>
  <category>Shopping</category>
</categories>开发者_如何学C

I need a LINQ query ( lambda expression) that returns the results in the following format :

categories = Find product,Shopping

---

That sounds like:

var categories = doc.Descendants("category") // Find "category" elements
                    .Select(x => (string) x); // Select the string value

// In .NET 4
string joined = string.Join(",", categories);

// In .NET 3.5 (fewer overloads for Join)
string joined = string.Join(",", categories.ToArray());