I had a couple of requests for the code I used to build my sql script on the fly in conjunction with NAntContrib (blogged about it here). Before I show the code, my next refactoring would include (1) creating a ProcessState interface and generating seperate ProcessState classes for NAnt and MultiThreaded environments and (2) do the same for vssManager to handle multiple source control engines.
Before I list the code, I suppose I should add a CMA disclaimer:
The code listed below is offered without any warranty expressed or implied. This is despite anything stated before, after or during this posting. To understand the scope of this lack of a warranty, understand that no guarantee is made that code will compile and if it does compile and actually accomplishes anything it is merely a coincidence on par with a monkey randomly banging on a typewriter and producing a word-for-word copy of Hamlet. If you use the code and it causes you any problems, you assume full responsibility for the problems and obsolve the author of any form of responsibility.
I should have been a lawyer... now for the code...
using System;
using System.Collections;
using System.IO;
using SourceSafeTypeLib;