I started to rewrite the application using some patterns I have been learning about, particularly the Abstract Factory Method pattern, which allows for a generic database interface to be used. Making the application easily ported to new databases in the future.

Rexall was sold, and I lost my job along with 300 others, and been at a new job for a while now. You can see that in the resume page (which job I am currently at and what I am doing, etc.).

I really dont like the old code base, never commented it much, etc. Never finished it, it generated sprocs but ones that wouldnt run, and I had to manually edit the sprocs to get them to work, but saved about 90% of the work I had to do in writing the original sprocs.

I used a XMLTextReader object which is forward-only, read-only access to a stream of XML data. This provided me with a very fast way to parse each of the XML documents, as when I did it with the XMLDOM and XPath it was ultra slow compared to the XMLTextReader. Anywho, its now in the download section, keep in mind that the new version is coming using the Abstract Factory Method if there is enough interest.

Code is now available via the download link on the left! Enjoy, and please e-mail me with flames or comments on the code.. :-D

Well as you can probably tell, I never got that beta out the door for general consumption. Time at my new job had stolen most of my free time away, due to the fact that I was learning and doing nothing but .NET at Rexall Sundown, Inc.

Well, the company was sold just Monday of this week, and there is a lot of uncertainty so I updated my resume and saw that these sections are very neglected :-).

I am thinking of re-designing this applicaiton, and use full .NET compliant code. This version of the sprocgen is actually running with SQL DMO, which uses interop and needs libraries I would rather not have to require. I would really like to use the .NET framework for discovery, and work with it that way. Also my skills in .NET have been polished quite a bit since being at Rexall, so that will help make a better application.

If your still interested, keep an eye out, I will be posting something again soon. I put up an initial screenshot teaser for this application just now. Enjoy!

Have an internal beta going, and its going pretty good. Found a few bugs, minor ones really, patching them up. I am really impressed with .NET's installer package, very sweet.

I need to clean up the code a bit (add some configuration menu's, etc as it is all hard coded at the moment). Then do some documentation and it should be ready for general release.

If you would like to recieve a beta copy, and give me some feedback, go ahead and e-mail me! Thanks.

Hmm.. 1:13am and I have a beta version of the software on my hands!! Aww yeah, currently it only does select, update (very simple), delete (very simple) sprocs. It currently supports where, select, from, table names, colums selected, case when then, and order by. More to come shortly now that I have the engine in place.

Note: I only have tested fully the select XML template I had put together. In the next few days I will be working on an update and delete XML template to put some hair on it as well, with lots of information and make sure that I have as much functionality as possible.

If your interested in see'ing the select XML document, here it is.

Wow, long night. If you havent read in the Game Assistant section of the site, I have been hard at work at another version of the site. Finally done! This section recieved 3 new areas, available on the left. These will allow you to look at more information as to what this program will be, and where its going.

Add your own comments by sending me an e-mail through the contact link above.

Sproc on!

The launch of this section is official! I will be building out this section in the coming weeks to outline my plans for this project, and keep you informed as to where I am with it.

If this program interests you, and you would like to be on the beta team, please drop me a note at the Contact Me link above. Also if you have any ideas you would like to see in the finished product (although I doubt it will ever be "finished", I have lots of ideas for versions 2 and 3 already) you can drop me a note as well!