C# Linq XML GroupBy OrderBy获取计数

using System;
using System.Linq;
using System.Xml.Linq;

class Program
{
    static void Main()
    {
        // 加载XML数据
        XDocument doc = XDocument.Load("data.xml");

        // 使用LINQ查询语句
        var result = from element in doc.Descendants("item")
                     group element by element.Element("category").Value into g
                     orderby g.Key
                     select new
                     {
                         Category = g.Key,
                         Count = g.Count()
                     };

        // 输出结果
        foreach (var item in result)
        {
            Console.WriteLine("Category: " + item.Category);
            Console.WriteLine("Count: " + item.Count);
            Console.WriteLine();
        }
    }
}

<root>
    <item>
        <category>Category A</category>
        ...
    </item>
    <item>
        <category>Category B</category>
        ...
    </item>
    ...
</root>