https://stackoverflow.com/questions/63329041/how-to-parse-xml-file-in-c-sharp-to-create-a-table-in-sql-server-database

CSharp · Console

/Program.cs

using System;
using System.Collections.Generic;
using System.Collections;
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.Reflection;
using System.Xml.Schema;

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

    //https://stackoverflow.com/questions/63329041/how-to-parse-xml-file-in-c-sharp-to-create-a-table-in-sql-server-database

    class TestClass
    {
        public static void Test()
        {
            var xsdString = GetXsd();

            // Load the xsdString into an XmlSchemaSet.
            // If loading from a file use a StreamReader rather than a StringReader
            XmlSchemaSet schemaSet = new XmlSchemaSet();
            using (var reader = new StringReader(xsdString))
            {
                schemaSet.Add(XmlSchema.Read(reader, null));
            }

			// Compile the schema
            schemaSet.Compile();

            // Iterate over the schemas
			// Code adapted from https://docs.microsoft.com/en-us/dotnet/standard/data/xml/traversing-xml-schemas
            foreach (XmlSchema schema in schemaSet.Schemas())
            {
                // Iterate over the complex types in the schema
                foreach (XmlSchemaElement element in schema.Elements.Values)
                {
                    var complexType = element.ElementSchemaType as XmlSchemaComplexType;
                    if (complexType == null)
                        continue;

                    Console.WriteLine("Complex element: {0}", element.Name);

                    // If the complex type has any attributes, get an enumerator
                    // and write each attribute name to the console.
                    if (complexType.AttributeUses.Count > 0)
                    {
                        var enumerator = complexType.AttributeUses.GetEnumerator();
                        while (enumerator.MoveNext())
                        {
                            var attribute = (XmlSchemaAttribute)enumerator.Value;
                            var name = attribute.Name;
                            var type = attribute.AttributeSchemaType.TypeCode;

                            Console.WriteLine("   Attribute {0}: {1}", name, type);
                        }
                    }

                    // Get the sequence particle of the complex type.
                    var sequence = complexType.ContentTypeParticle as XmlSchemaSequence;
                    if (sequence != null)
                    {
                        // Iterate over each XmlSchemaElement in the Items collection.
                        foreach (XmlSchemaElement childElement in sequence.Items)
                        {
                            var name = childElement.Name;
                            var type = childElement.ElementSchemaType.TypeCode;

                            Console.WriteLine("   Element {0}: {1}", name, type);
                        }
                    }
                }
            }
        }

        static string GetXsd()
        {
            return @"<?xml version=""1.0""?>
<xs:schema xmlns:xs=""http://www.w3.org/2001/XMLSchema"">
<xs:element name=""Student"">
  <xs:complexType>
    <xs:sequence>
    <xs:element name=""Id"" type=""xs:integer""/>
    <xs:element name=""Name"" type=""xs:string""/>
    <xs:element name=""City"" type=""xs:string""/>
    </xs:sequence>
  </xs:complexType>
</xs:element>
</xs:schema>";
        }
    }

	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;
		}
	}