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/58938830/how-to-set-c-sharp-datatable-locale-to-be-utc

​

#if false

@ManInMoon - setting `table.Columns["utcDT"].DateTimeMode = DataSetDateTime.Utc;` seems to generate the correct output: `utcDT>2019-11-19T21:08:00Z</utcDT>`.  See: https://dotnetfiddle.net/zNuI2N.  If I don't set the `DateTimeMode` I get the wrong output, see https://dotnetfiddle.net/RyXCnH.  This looks like a duplicate of [How to persist DateTime Kind while storing a datetime object into a data table?](https://stackoverflow.com/a/3990942/3744182) which was linked to above.  

​

Incidentally, after setting `DateTimeMode ` the schema for `"utcDT"` changes as follows: `<xs:element name="utcDT" msdata:DateTimeMode="Utc" type="xs:dateTime" minOccurs="0" />`.  Note the addition of the `msdata:DateTimeMode` attribute.

#endif

​

    public class TestClass

    {

        static string GetDataSetXsd()

        {

            return @"<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:MainDataTable=""Test"" msdata:Locale=""en-US"">

      <xs:complexType>

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

          <xs:element name=""Test"" msdata:Locale=""en-US"">

            <xs:complexType>

              <xs:sequence>

                <xs:element name=""utcDT"" type=""xs:dateTime"" minOccurs=""0"" />

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

                <xs:element name=""Close"" type=""xs:double"" minOccurs=""0"" />

              </xs:sequence>

            </xs:complexType>

          </xs:element>

        </xs:choice>

      </xs:complexType>

    </xs:element>

</xs:schema>

";

        }

        static DataSet CreateDataSet()

        {

            DataSet ds = new DataSet();

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

            {

                ds.ReadXmlSchema(reader);

            }

            var table = ds.Tables[0];

            table.Columns["utcDT"].DateTimeMode = DataSetDateTime.Utc;

​

            var row = table.NewRow();

            row["utcDT"] = DateTime.Parse("2019-11-19T16:08:00-05:00").ToUniversalTime();

            row["Symbol"] = "Widget";

            row["Close"] = 31.25;

​

            table.Rows.Add(row);

            return ds;

        }       

        public static void Test()

        {

            var ZeroMQTopic = "Test";

            var ds = CreateDataSet();

            var table = ds.Tables[0];

            StringWriter sw = new StringWriter();

            table.TableName = ZeroMQTopic;

            table.WriteXml(sw, XmlWriteMode.WriteSchema);

            string tableXML = sw.ToString();            

            Console.WriteLine(tableXML);

        }

    }

​

    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;

        }

    }

​