I'm working on winform app using local sqlitedb. I'm able to embedded db to application file when deploy. But I got two problem:
- I can find the local.db(DEPLOY type) file but when try to read it using DB Browser, it returned blank db without any data inside. The app itself still working perfectly fine with all data in the .db file. So where can I find the .db file which acture have data inside?
- The second problem is. I'm syncing local sqlite database with a remote Google Cloud DB. Everything works on debug but in deployment the sync function can not keep tracking changes in .db file and return 0 changes. I assume it's because in application file, the .db file is blank without any data inside so the sync function can not track and sync 2 databases. I'm using DotMim(0.9.7) to sync.