I have an complex XML file which has lots of nested elements and need help in creating a program/method that parses this information into a single flat table (dataset object). Please refer to the sample XML file attached so you can get a better idea of what it looks like.
I'm currently working on a C# program that will read this xml file and put it in a SQL Server database/table.
However, because the file has a lots of nested elements I'm struggling a bit to turn this into a single table where I can see all of the data. Hoping that a skilled freelancer that has experience in working with XML and C# can create this.
Each base element (<ServiceFeeEventList> or <RefundEventList>) have its own columns but some are present in each, like CurrencyAmount or SellerSKU and so when every element is combined into the single table, use the same column wherever it appears (in other words, no duplicate columns)
So, here's what I need:
- a C# program/method that takes a string parameter to either A) path to the XML file or B) the actual XML text
- Generic enough so that it can work with other elements that are not present in the provided sample, ideally without having to adapt the code.
Looking forward to your input. Let me know if you've done something similar.