How to add scripts to C# package project

[ISRAEL]

Hi there

I’m a newbie. I just want to know how to add a script to the C# Package project. I have some scripts that I have to run before the sync script produced by packager wizard.

Thanks
_________________
Israel

[james.billings]

Thanks for your post.
The SQL that is created by packager is stored as resources in the C# project, and I don't think you can easily amend these. The generated application does support the /presql and /postsql commands though, so you can supply a .sql script as a commandline option when executing the built package.

If you wanted to incorporate the extra commands directly into your package when compiling, it's perhaps a little trickier and not something i've tried before.
A look at the project shows that the /presql and /postsql switches set a couple of properties in the PackageExecutor class. You'll see the Execute method in there calls: