CODEWITHSUNDEEP
c#visual-studio-2010sqlitemsbuildportable-database
Jader Dias
Jader Dias

Reputation: 90475

How do you create portable databases with MsBuild?

I want to store in my solution a project containing the database creation scripts. When this project is built, it must generate a database file, which will then be used by this and other projects of the solution at the run time. How to do that?

I know I can add Pre-Build task, but I wonder:

Upvotes: 3

Views: 331

Answers (2)

Suraj
Suraj

Reputation: 96

try Access db(extension: accdb)...its easy to edit and can be backed up and used with Office access..as well.also its portable..

Upvotes: -1

Jader Dias
Jader Dias

Reputation: 90475

You can download the command line client shell for SQLite at http://www.sqlite.org/download.html

Then you can add the following Pre-Build task:

"sqlite3.exe" %dbFilename% < Database.sql

Upvotes: 1

Related Questions