xSQL Builder - Appendix A

Running the code template project in VS.NET 2005

 

xSQL Builder ships with a VS.NET 2005 C# project that contains the code templates used to generate the executable package. You can open this project in VS.NET 2005, modify it, add additional classes to address your particular environment requirements. xSQL Builder compiles all the files with .cs extension in the code template folder and includes them in the executable package. You should not remove from the project or change the name of the class EntryPoint.

Every time you generate a package, xSQL Builder copies the configuration file and the snapshot of the master databases on the \Resources folder under the code template folder. The configuration file is always named config.xml, the snapshot is named as SqlServerName.DatabaseName.snp. Note that invalid file chars on the snapshot name are replaced with underscore "_". To run code template project in VS.NET 2005 do the followings:

• Add references to runtime dll listed in the Appendix A. you can find these dll under the xSQL builder installation folder.
• Add the files config.xml and the master snapshot file in the project. Both files are located in the \Resources subfolder.
• In the VS.NET property window, set the "Build Action" property to "Embedded Resource" for both files.

Dll files are located in the xSQL Builder main installation folder.