c# - How can I parse T-SQL to AST using the classes in Microsoft.SqlServer.Management.SqlParser

Question

The class Parser only has the method Parse that returns a ParseResult, and seems I can do nothing with the ParseResult. How can I get the abstract syntax tree of my sql statement, or just the metadata tokens can be parsed from sql is fine.

Answer 1

I did some research, and found that I can use reflection to generate the parsed information xml file using SqlScript.WriteXml. And here's is the sample code, I don't know if there is any better way.

var rst = Parser.Parse(File.ReadAllText(@"*.sql"));
var fieldInfo = rst.GetType().GetField("sqlScript", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.GetField);
var script = fieldInfo.GetValue(rst);
var writer = XmlWriter.Create("*.xml");
script.GetType().InvokeMember("WriteXml", BindingFlags.NonPublic| BindingFlags.Instance | BindingFlags.InvokeMethod
    , null, script, new object[] { writer });
writer.Close();