how would I call/use Subsonic from within a WinForms app being deployed over clickonce (with Sqlite
- by Greg
Hi,
Background - I need a framework/approach to managed database updates for a .NET Winforms app being deployed on users PC's via clickonce deploy. The app uses a sqlite database.
Q1. What mechanism does Subsonic use to run such migrations on the local PC? e.g. would it be MSBuild
Q2. If it does need a tool like how can my application robustly kick off MsBuild? i.e. how can it be sure what path it is installed, what if it is not installed, should I be including the MSBuild.exe in the clickonce package so that I know it is there for sure myself?
Q3. Any other suggestions on how to use Subsonic in this specific use case?
Q4. Any comments on whether MigratorDotNet would be a better fit? (if someone has had experience with both)
Q5. Could I use subsonic's bare migration framework and just have a set of SQL files to do the upgrade/downgrade? i.e. just use the framework to check database version and which scripts to run etc?