question

DineshkumarS-4414 avatar image
0 Votes"
DineshkumarS-4414 asked karenpayneoregon answered

Database change connection in sqlite

I have made some database change in my local SQLite for a windows form app using c# but when i generate the build and run in another system the database changes made are not available they are goin off so how to check how the sync is happening in the app n??

dotnet-csharpdotnet-sqlite
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AgaveJoe avatar image
0 Votes"
AgaveJoe answered AgaveJoe edited

You asked this question as if the community knows what you are thinking and how you application works.

Since Sqlite is a local database, I'm guessing your deployment process does not copy the correct database or your seed logic does not work properly. But, this is only a guess.

If you want community debugging services, then share enough code to reproduce this issue.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered DineshkumarS-4414 commented

That's to less on informations.
How do you create/update the database? A Code First Entity Framework solution? Own code? With a tool?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

with a tool

0 Votes 0 ·
karenpayneoregon avatar image
0 Votes"
karenpayneoregon answered

Seems like you need to consider how do changes affect current data prior to database changes if any and if so you need to write code to handle current data and if it does not affect current data redistribute the new database to the client.

When considering adapting to current data, create say a console utility that first backs up current data, modify to suit the new schema followed by validating the changes work all done on your development machine than once satisfied give the utility to clients.

What is involved in writing a utility, you have not supplied enough information to tell you but best advice is to write out requirements than work from there.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.