通过使用LINQ to XML获取XML中的元素值

我试图通过使用LINQ到XML来获取XML文件的值。

下面是XML文件的示例块。

<SECTION NAME="Details">
    <COLUMNS>
        <COLUMN NAME="STOCK.STOCK_CODE">CODE A</COLUMN>
        <COLUMN NAME="STOCK.DESCRIPTION">Product A</COLUMN>
        <COLUMN NAME="STOCK.SALES_PRICE">43.65</COLUMN>
        <COLUMN NAME="STOCK.SUPPLIER_PART_NUMBER"></COLUMN>
        <COLUMN NAME="STOCK.UNIT_WEIGHT">65.50</COLUMN>
        <COLUMN NAME="STOCK.OUT_OF_STOCK">0</COLUMN>
        <COLUMN NAME="STOCK.BRAND">ADDIDAS</COLUMN>
        <COLUMN NAME="STOCK.CATEGORY1">MEN</COLUMN>
        <COLUMN NAME="STOCK.CATEGORY2">TOILETERIES</COLUMN>
    </COLUMNS>
</SECTION>
<SECTION NAME="Details">
    <COLUMNS>
        <COLUMN NAME="STOCK.STOCK_CODE">CODE B</COLUMN>
        <COLUMN NAME="STOCK.DESCRIPTION">Product B</COLUMN>
        <COLUMN NAME="STOCK.SALES_PRICE">18.95</COLUMN>
        <COLUMN NAME="STOCK.SUPPLIER_PART_NUMBER">30.45</COLUMN>
        <COLUMN NAME="STOCK.UNIT_WEIGHT">38.50</COLUMN>
        <COLUMN NAME="STOCK.OUT_OF_STOCK">0</COLUMN>
        <COLUMN NAME="STOCK.BRAND">REVLON</COLUMN>
        <COLUMN NAME="STOCK.CATEGORY1">WOMEN</COLUMN>
        <COLUMN NAME="STOCK.CATEGORY2">PERFUMES</COLUMN>
    </COLUMNS>
</SECTION>

我使用LINQ to XML将值获取到对象中。而不是使用固定位置，我想通过使用"NAME"的值来获得值。请指导我如何选择这些值?谢谢。

foreach (var page in root.Elements("PAGE").Elements("SECTIONS").Elements("SECTION"))
                {
                    CurrentProduct = string.Empty;
                    if (page.Attribute("NAME").Value == "Details")
                    {
                        var sec = page.Element("COLUMNS");
                        UploadPrice pp = new UploadPrice();
                        pp.Code = sec.Elements("COLUMN").ElementAt(0).Value;
                        pp.Net = sec.Elements("COLUMN").ElementAt(2).Value;
                        pp.POR25 = sec.Elements("COLUMN").ElementAt(3).Value;
                        pp.SSP = sec.Elements("COLUMN").ElementAt(4).Value;
                        UploadPrices.Add(pp);
                    }
                }