Text Template Transformation

My team stores some database logic in an XML file that is part of a CSharp project.
This seems to be working efficiently for the application in runtime and for developers to maintain their SQL statements at design. I don't like it because the file has gotten large and finding things is a manual process.
I am trying to keep up with innovations, so I wrote a transformation that changes that XML file into a class. That way Visual Studio can provide its drop-down navigation controls for finding statements in the file.

<#@ template language="C#" #>
<#@ output extension = "cs" #>
<#@ assembly name="System.Xml.dll" #>
<#@ import namespace = "System.Xml" #>


public class SQLConfig {
<# 
   XmlDocument doc = new XmlDocument();
   doc.Load("C:\\Projects\\MySolution\\MyDataLayer\\ORACLESQL.config");
   
   foreach(XmlNode node in doc.SelectNodes("//add")) {
   
   #>
   
   public const string <#= node.Attributes[0].Value.Replace(".","_").Replace("-","_") #> = @"<#= node.InnerText #>";
   
   <#   
    }
    
    doc = null;
   #>
   }
   

What this does is create a Class file using the above code every time the transform template is changed, or the developer can right-click "Run Custom Tool" on it.