Converting an XML schema from Enterprise Architect to an SQL Script using c# codes

good day everyone, im just having an application which would convert a scema to sql scripts, as of now i am reading the source xml file and generate a new xml file based on my template..then the output xml will be used to generate the sql script, this process is also the one i have used in creating classes, objects, and interface stubs. I would appreciate if anyone can help me do it in a simpler way..just be noted that only domain objects were present in the scema and therefore contains incomplete data to produce the desired output, thats why i have hard coded some of the id's specially the foreign keys. I would be waiting for your replies! thanks guys, in advance!