using System;

using System.Collections.Generic;

using System.Text;

using System.Linq;

using System.Xml.Serialization;

using System.Xml;

using System.Xml.Linq;

using System.IO;

using System.Data;

using System.Runtime.Serialization;

using System.Runtime.Serialization.Formatters.Binary;

using System.IO.Compression;

using System.Reflection;

​

using NUnit.Framework; //NUnit.Framework.AssertionException

​

//https://stackoverflow.com/questions/66739322/i-am-having-trouble-moving-data-from-an-xml-file-into-an-array-with-cdata-node-t

​

    public class TestClass

    {

        public static void Test()

        {

            var FilePath = @"Question66739322.xml";

            try

            {

                File.WriteAllText(FilePath, GetXml());

​

                var doc = XDocument.Load(FilePath);

                XNamespace ns = ""; // Replace with @"http://intelliquip.com/integrationS..." can't see the full namespace from the XML image.

                var query = from quote in doc.Descendants(ns + "quoteNumber")

                    let order = quote.ElementsAfterSelf(ns + "orderNumber").FirstOrDefault()

                    where order != null

                    select Tuple.Create(quote.Value, order.Value);

                var list = query.ToList();

​

                Console.WriteLine("Deserialized list:");

                Console.WriteLine(Newtonsoft.Json.JsonConvert.SerializeObject(list, Newtonsoft.Json.Formatting.Indented));

            }

            finally

            {

                File.Delete(FilePath);

            }

        }

        static string GetXml() => @"<foo>

<bar>

<quoteNumber>

<![CDATA[ John Test 123]]>

</quoteNumber>

<orderNumber>

<![CDATA[ 1352738]]> 

</orderNumber>

</bar>

</foo>

";

    }

​

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: {0} ({1})", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , GetNetCoreVersion());

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

                Console.WriteLine("Failed with unhandled exception: ");

                Console.WriteLine(ex);

                throw;

            }

        }

        public static string GetNetCoreVersion()

        {

            //https://techblog.dorogin.com/how-to-detect-net-core-version-in-runtime-ecd65ad695be

            //

            var assembly = typeof(System.Runtime.GCSettings).GetTypeInfo().Assembly;

            var assemblyPath = assembly.CodeBase.Split(new[] { '/', '\\' }, StringSplitOptions.RemoveEmptyEntries);

            int netCoreAppIndex = Array.IndexOf(assemblyPath, "Microsoft.NETCore.App");

            if (netCoreAppIndex > 0 && netCoreAppIndex < assemblyPath.Length - 2)

                return assemblyPath[netCoreAppIndex + 1];

            return null;

        }

    }

​