using System;

using System.Data;

using ChoETL;

​

public class Program

{

    public static void Main()

    {

            var reader = ChoXmlReader.LoadText(xml);

        DataTable dataTable = reader.AsDataTable();

​

        // Print the columns of the DataTable

        foreach (DataColumn column in dataTable.Columns)

        {

            Console.WriteLine("Column Name: " + column.ColumnName);

        }

​

        // Print the column names, values, and types for each row

        foreach (DataRow row in dataTable.Rows)

        {

            foreach (DataColumn column in dataTable.Columns)

            {

                var value = row[column];

                Console.WriteLine($"Column Name: {column.ColumnName}, Value: {value}, Type: {value.GetType()}");

            }

            Console.WriteLine(); // Add a blank line between rows for readability

        }

    }

    static string xml = @"<?xml version='1.0' encoding='UTF-8'?><!DOCTYPE TRANSACTIONS SYSTEM 'transactions.dtd'><Employees>

     <TRADE>

        <INVNUM>-28610</INVNUM>

        <MATURITY>8/21/2024</MATURITY>

        <CUSIP>BSGD77HS1</CUSIP>

         <TRD_ENTRY_TIME>8/22/2024 6:00:24.000</TRD_ENTRY_TIME>

          <TRD_ORIG_FACE>-1904.0000000000</TRD_ORIG_FACE>

    </TRADE>

     <TRADE>

        <INVNUM>-20517</INVNUM>

        <MATURITY>8/21/2024</MATURITY>

        <CUSIP>BSGD77HS1</CUSIP>

        <TRD_ENTRY_TIME>8/22/2024 6:00:25.000</TRD_ENTRY_TIME>

        <TRD_ORIG_FACE>-762.0000000000</TRD_ORIG_FACE>

    </TRADE>

</Employees>";

}