Static Lookup Data Generators for Visual Studio Team System 2008 Database Edition
Updated: Now that the Power Tools for VS2008 have been released, I recommend that you use the Sequential Databound Generator, FileBound Generator, and Data Generation Wizard for these scenarios.
A while back, I put up a sample implementation of a custom data generator for VS 2005, to allow the generation of known static lookup values in a data generation plan. This was just something I was using to fill a gap until Microsoft released the Power Tools for VSTS 2005 DB Pro, which came with the Sequential Databound Generator, which was way more robust. When VS 2008 was released, the Sequential Databound Generator was not included. It was intimated that this critical gap would be filled with an updated Power Tools for VSTS 2008 DB release soon, but until that day comes, I have been using an updated implementation of the original sample code, that will work with VS 2008. I've added static value generators to output the following .NET data types: bool, byte[], DateTime, int, string, as well as an installer.
Usage instructions from the original post still apply.