C# XML Transformation using XSLT

If you have one type of XML and need to transform it to another type, then you can use XSLT for that purposes. For instance in the health care field, there are a lot of XML standards, such as CCD, CCR etc. Sometimes one type of XML need to be transformed to another one. The best way to do it is to use XSLT. You may ask where do you get appropriate XSLT for specific XML transformation? Well, for example I use Altova MapForce. MapForce allows you to do XML transformation manually by simply dragging appropriate attributes. Once you done with that, MapForce will generate an XSLT which you can use then in your code.

Ok, we got an XSLT file, here is how we use it in C# code in order to transform XML file:

class Program
{
    static void Main(string[] args)
    {
        TransformXML("XML.xml", "XMLtoCCD.xslt");
    }

    public static void TransformXML(string sXmlPath, string sXslPath)
    {
        try
        {
            /* loading XML */
            XPathDocument myXPathDoc = new XPathDocument(sXmlPath);
            XslCompiledTransform myXslTrans = new XslCompiledTransform();
            /* loading XSLT */
            myXslTrans.Load(sXslPath);
            /* creating Output Stream */
            XmlTextWriter myWriter = new XmlTextWriter("result.xml", null);
            /* XML transformation */
            myXslTrans.Transform(myXPathDoc, null, myWriter);
            myWriter.Close();
        }
        catch (Exception e)
        {
            Console.WriteLine("Exception: {0}", e.ToString());
        }
    }
}

That's it! If you have any questions, please ask, I'll be happy to help.