Hello,
I've been asked by my supervisor to document VBScript code in our existing
ASP classic pages .. primarily, what hooks we've got into our SQL databases
using ADO.
Right now, I've written some C# code which recursively parses all ASP files
in a site to extract out all client and server-side procedures. However,
I'd like to take it a step further (if possible) to actually something akin
to an EVAL(); not to actually run the code but to intelligently recognize
what types of ADO objects are being used and against what tables, stored
procs, etc.
I realize this sounds like a big pain, but less so than having to sift
through hundreds of pages, many of which do some type of database
interactions.
That all said, I've heard bits/pieces about the concept of reflection in
..NET, but I'm not sure if that would help with trying to parse VBscript code
... that may be a case of just enough knowledge to hurt me without
understanding the scope of what it can do. :-)
Worst case would be that I could use lots of string parsing, but I was
hoping for a more systemic approach. I figure there's about a 1% chance of
coming up with something for this, but I thought I'd ask.
thanks!!!
Dan