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/65459492/token-startelement-in-state-epilog-would-result-in-an-invalid-xml-document

​

    public class TestClass

    {

        public static void Test()

        {

            DataTable dtTest = new DataTable();

            dtTest.Columns.Add("Name");

            dtTest.Columns.Add("NickName");

            dtTest.Columns.Add("Code");

            dtTest.Columns.Add("reference");

​

            dtTest.Rows.Add("Yash", "POPs", "Vapi", "None1");

            dtTest.Rows.Add("shilpa", "shilpa", "valsad", "None2");

            dtTest.Rows.Add("Dinesh", "dinu", "pune", "None3");

            dtTest.Rows.Add("rahul", "mady", "pardi", "None4");

            XmlWriterSettings settings = new XmlWriterSettings();

            var stringwriter = new StringWriter();

            using (var xmlWriter = XmlWriter.Create(stringwriter, new XmlWriterSettings {  Indent = true }))

            {

                xmlWriter.WriteStartDocument();

                xmlWriter.WriteStartElement("Root");

                foreach (var row in dtTest.AsEnumerable())

                {

                    xmlWriter.WriteStartElement("Row");

                    xmlWriter.WriteAttributeString("orderid", row.Field<string>("Name"));

                    xmlWriter.WriteElementString("type",  row.Field<string>("Name"));

                    xmlWriter.WriteElementString("status", row.Field<string>("Name"));

                    xmlWriter.WriteElementString("productno", row.Field<string>("Name"));

                    xmlWriter.WriteEndElement();

                }

                xmlWriter.WriteEndElement();

            }

            var xml = stringwriter.ToString();

            XmlDocument docSave = new XmlDocument();

            docSave.LoadXml(xml);   

            Console.WriteLine(docSave.GetOuterXml());

        }

    }

​

    public static class XmlSerializationHelper

    {

        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 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.Location.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;

        }

    }

​