SqliteWasmHelper + DotMimSync

[sidmcfarland]

Hi Jeremy...

I watched your video with Sebastian and DotMimSync. Pretty cool. I'm working on an app now that could make use of both SqliteWasmHelper AND DotMimSync (with sync over HTTP), but I'm not able to get it working. I suspect this is a limitation of SqliteWasmHelper since I got it working with a SQLite DB and DotMimSync over HTTP in a console app.

I'm creating a Blazor WASM app that needs to store data while offline (preferably in SQLite) and then sync that data with a SQLServer DB on the backend when online. For security reasons, I've used DotMimSync's ability to sync over HTTP. Works great with a sample console app. However, in the Blazor WASM app using SqliteWasmHelper I'm getting errors that seem to indicate the session information generated by DotMimSync is being lost between requests. I'm not sure if maybe SqliteWasmHelper and DotMimSync will work together.

Do you know if anyone has accomplished this? Or, if this is a limitation of SqliteWasmHelper, is it possible to update it so it's capable of working with DotMimSync over HTTP?

[sidmcfarland]

One thing I noticed is that in my console app that uses DotMimSync, there appears to be more items created in the SQLite DB than my Blazor WASM app that uses DotMimSync and SqliteWasmHelper. Note the differences. Is it possible SqliteWasmHelper is not able to create some of the DB assets that DotMimSync requires to perform a sync?

SQLite DB created in Blazor WASM app (left) and SQLite DB created in console app (right)