OK this is what I would do to create the CSV base on reflection. I would serialize the object to XML and then the resulting XML converted using XSLT to CSV:
namespace ConsoleApplication1
{
[XmlRoot(ElementName = "Players")]
public class Players : System.Collections.Generic.List<Player> {
public Players() { }
}
public class Player{
public string Name { get; set; }
public string Team { get; set; }
public string Position { get; set; }
public Player(string name, string position, string team) {
this.Name = name;
this.Position = position;
this.Team = team;
}
public Player() { }
}
[System.Runtime.InteropServices.GuidAttribute("D36900FE-8902-4ED8-B961-DE5B3F3273AC")]
class Program
{
static void Main(string[] args)
{
Players players= new Players();
players.Add(new Player("C.Ronaldo", "Man Utd", "Midfielder"));
XmlSerializer ser = new XmlSerializer(typeof(Players));
var writer = new System.IO.StreamWriter(@"C:\myxml.xml", false);
ser.Serialize(writer, players);
writer.Flush();
writer.Close();
var myXslTrans = new XslCompiledTransform();
myXslTrans.Load(@"C:\CSV.xslt", null, null );
myXslTrans.Transform(@"file://C:/myxml.xml", @"C:\converted.csv");
}
}
}
This is my sample XSLT:
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:telerik="remove" xmlns:asp="remove">
<xsl:template match="/">
<xsl:for-each select="Players/Player">
<xsl:value-of select="Name" />,<xsl:value-of select="Team" />,<xsl:value-of select="Position" />
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>
Disclaimer:
I know the XSLT needs break lines or may need additional formats. I only intent to describe a possible path to CSV/Reflection and not a fully working solution.
