How do you use portable databases with MsBuild?

Question

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

I know that I can add a Pre-Build task, but I'm wondering:

• which command can help me (maybe sqlite has a command line client?)
• Do I need to create an empty database file before running the scripts?

Answer 1

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

Pre-Build:

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

Answer 2

Access db (: accdb)... , Office.. . .