Resgrid.Console.exe dbupate throws unhandled exception about core HOT 6 CLOSED

Ive added your suggested fix and pushed it up. https://github.com/Resgrid/Core/pull/20/files#diff-7d4c97ef391c3330c175ddf7077c0646e3d77994ea8be2c54de0bbc36fb94e1d I'll be working on testing everything out this weekend to try and get the new release pushed out.

from core.

I implemented your fix in #21.

from core.

Hey @anewio thanks for the report!! If you want to deploy and update the db, we use fluent migrator and you can deploy it like this:

dotnet tool install -g FluentMigrator.DotNet.Cli
dotnet fm migrate -p SqlServer -c "[YOUR CONNECTION STRING]" -a "C:\Resgrid\Tools\Resgrid.Providers.Migrations.dll"

I'll look at getting that above error fixed as well.

from core.

Thanks @ucswift for the quick response. With the latest commit, `Resgrid.Console.exe dbupate' moves down few steps but ends up with another exception, see attached.

Above error message tells FluentMigrator was not able to load the embedded migration SQL file: M0001_InitialMigration.sql for some reasons. The root cause doesn't seem obvious to me in the first place. After few research, I believe the fix is to add one more function call (see line #66) in the FluentMigrator configuration routine at file: DbUpdateCommand.cs as below (see line #65 and #66). After the fix, `Resgrid.Console.exe dbupate' finally works successfully.

from core.

@anewio do you get the error if you use the FluentMigrator.DotNet.Cli tool? I've been using that at the moment, but trying to get the Cli working to match documentation. Thanks for that research too, I'll get that added to the code.

from core.

@anewio do you get the error if you use the FluentMigrator.DotNet.Cli tool? I've been using that at the moment, but trying to get the Cli working to match documentation. Thanks for that research too, I'll get that added to the code.

CLI appears working.

from core.