How can I create a new SQLite database, with all tables, on the fly?

Viewed 38319

When a user starts my app he or she can create a new project, which means creating a new database with all tables.

I don't want to copy the structure of the tables from an older database/project because in the meantime, the tables could have changed due to an update by the program. This would lead to crashes.

So with every application update I deploy, I should also deploy a script file which creates the database and tables, right?

What should the script file look like and how would you call it in C#?

3 Answers
Related