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/65965967/can-dataset-be-loaded-into-xmldocument

​

    public class TestClass

    {

        public static void Test()

        {

            var dataSet = CreateDataSet();

​

            TestXmlDocument(dataSet);

            TestXDocument(dataSet);

        }

​

        static void TestXmlDocument(DataSet dataSet)

        {

            var doc = new XmlDocument();

            var navigator = doc.CreateNavigator();

            using (var writer = navigator.AppendChild())

            {

                dataSet.WriteXml(writer);

            }           

​

            Console.WriteLine("\nCreated {0}:", doc.GetType().Name);

            Console.WriteLine(doc.GetOuterXml());

        }

​

        static void TestXDocument(DataSet dataSet)

        {

            var doc = new XDocument();

            using (var writer = doc.CreateWriter())

            {

                dataSet.WriteXml(writer);

            }           

​

            Console.WriteLine("\nCreated {0}:", doc.GetType().Name);

            Console.WriteLine(doc.Root);

        }

        static string GetDataSetXsd()

        {

            var xsd = @"<?xml version=""1.0"" encoding=""utf-16""?>

<xs:schema id=""NewDataSet"" xmlns="""" xmlns:xs=""http://www.w3.org/2001/XMLSchema"" xmlns:msdata=""urn:schemas-microsoft-com:xml-msdata"">

  <xs:element name=""NewDataSet"" msdata:IsDataSet=""true"" msdata:UseCurrentLocale=""true"">

    <xs:complexType>

      <xs:choice minOccurs=""0"" maxOccurs=""unbounded"">

        <xs:element name=""Table"">

          <xs:complexType>

            <xs:sequence>

              <xs:element name=""ProjectID"" type=""xs:string"" minOccurs=""0"" />

              <xs:element name=""Title"" type=""xs:string"" minOccurs=""0"" />

              <xs:element name=""ProjectType"" type=""xs:string"" minOccurs=""0"" />

            </xs:sequence>

          </xs:complexType>

        </xs:element>

      </xs:choice>

    </xs:complexType>

  </xs:element>

</xs:schema>

";

            return xsd;

        }

​

        enum ProjectTypes

        {

            Open = 0,

            Closed,

            Lost,

            Found,

        }

​

        public static DataSet CreateDataSet()

        {

            DataSet dataSet = new DataSet();

            using (var reader = new StringReader(GetDataSetXsd()))

            {

                dataSet.ReadXmlSchema(reader);

            }

            for (int i = 0; i < 3; i++)

            {

                var row = dataSet.Tables["Table"].NewRow();

                row["ProjectID"] = (i * 2).ToString();

                row["Title"] = "Project Number " + i.ToString();

                row["ProjectType"] = ((ProjectTypes)(i % Enum.GetNames(typeof(ProjectTypes)).Length)).ToString();

                dataSet.Tables["Table"].Rows.Add(row);

            }

            dataSet.Tables["Table"].Rows.Add(dataSet.Tables["Table"].NewRow()); // Add troll row.

​

            return dataSet;

        }

    }

​

    public static class XmlSerializationHelper

    {

        public static T LoadFromXml<T>(this string xmlString, XmlSerializer serial = null)

        {

            serial = serial ?? new XmlSerializer(typeof(T));

            using (var reader = new StringReader(xmlString))

            {

                return (T)serial.Deserialize(reader);

            }

        }

​

        public static string GetXml<T>(this T obj, XmlSerializer serializer = null, bool omitStandardNamespaces = false)

        {

            XmlSerializerNamespaces ns = null;

            if (omitStandardNamespaces)

            {

                ns = new XmlSerializerNamespaces();

                ns.Add("", ""); // Disable the xmlns:xsi and xmlns:xsd lines.

            }           

            using (var textWriter = new StringWriter())

            {

                var settings = new XmlWriterSettings() { Indent = true }; // For cosmetic purposes.

                using (var xmlWriter = XmlWriter.Create(textWriter, settings))

                    (serializer ?? new XmlSerializer(obj.GetType())).Serialize(xmlWriter, obj, ns);

                return textWriter.ToString();

            }

        }

        public static string GetOuterXml(this XmlNode node, bool indent = true)

        {

            if (node == null)

                return null;

            using (var textWriter = new StringWriter())

            {

                var settings = new XmlWriterSettings

                {

                    Indent = indent,

                    OmitXmlDeclaration = true,

                };

                using (var xmlWriter = XmlWriter.Create(textWriter, settings))

                {

                    node.WriteTo(xmlWriter);

                }

                return textWriter.ToString();

            }

        }

    }

    public static class XmlAssert

    {

        // https://weblogs.asp.net/marianor/easy-way-to-compare-two-xmls-for-equality

        // https://stackoverflow.com/questions/7318157/best-way-to-compare-xelement-objects

        // Adapted from the answer https://stackoverflow.com/a/14463137 by https://stackoverflow.com/users/1102100/robjohnson

        public static void AreEqual(

            XElement expected,

            XElement actual)

        {

            Assert.IsTrue(XNode.DeepEquals(Normalize(expected), Normalize(actual)));

        }

​

        private static XElement Normalize(XElement element)

        {

            if (element.HasElements)

            {

                return new XElement(

                    element.Name,

                    element.Attributes()

                           .OrderBy(a => a.Name.ToString()),

                    element.Elements()

                           .OrderBy(a => a.Name.ToString())

                           .Select(e => Normalize(e)));

​

            }

​

            if (element.IsEmpty)

            {

                return new XElement(

                    element.Name,

                    "",

                    element.Attributes()

                           .OrderBy(a => a.Name.ToString()));

            }

​

            return new XElement(element.Name, element.Attributes()

                .OrderBy(a => a.Name.ToString()), element.Value);

        }

    }

    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;

        }

    }

​