Unable to read nodes for XML - Tridion Web 8.5

Question

While upgrading from Tridion 2011 to Web 8.5, unable to read nodes from XML. There are no values going in foreach.

XmlDocument config = new XmlDocument();                
config.LoadXml(xml);          
XmlNodeList doc = config.SelectNodes(Xpath);
foreach (XmlNode x in doc)
{
    HTValue.Add(x.Attributes["name"].Value.ToString(), x.Attributes["value"].Value);
    Console.WriteLine("Hash Name :" + x.Attributes["name"].Value.ToString() + " Hash Value : " + x.Attributes["value"].Value);
}

Answer 1

Looking at your code and comments about what you are trying to do.

Indeed your code seems to be okay, your XPath value is the one problem based on your input XML and XPath value.

You could try this sample code it works.

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

namespace TestConsoleApp
{
    public class Program
    {
        private static void Main(string[] args)
        {

            string XML = $"<?xml version=\"1.0\" encoding=\"utf-8\"?><configuration><appSettings><!--keys specific to auto-publish--><add key=\"abc\" value=\"xyz\" /><add key=\"abcd\" value=\"pqr\" /><add key=\"abce\" value=\"/Building%20Blocks/Content/def.xml\" /></appSettings></configuration>";
            XDocument document = XDocument.Parse(XML);
            foreach (XElement element in document.Root.XPathSelectElements("/configuration/appSettings/add"))
            {
                string key = element.Attribute("key") != null ? element.Attribute("key").Value : string.Empty;
                string value = element.Attribute("value") != null ? element.Attribute("value").Value : string.Empty;
                Console.WriteLine($"Key: {key}, Value: {value}");
            }
            Console.ReadKey();
        }
    }
}

I hope it helps.