How can i execute sqlite (sqlite3) statements in MSBUILD, the Exec Task?

Question

I am trying to run some queries on my sqlite database after building my application.

I have tried;

<Exec Command='sqlite3 "@(DeployedSqliteDbPath) DELETE FROM BatchConfig";'/>

and

<Exec Command='sqlite3 "@(DeployedSqliteDbPath)";'/>
<Exec Command='sqlite3 "DELETE FROM BatchConfig";'/>

But it doesn't seem to work. Can someone help?

See also http://stackoverflow.com/questions/4995597/how-do-you-use-portable-databases-with-msbuild — StayOnTarget, May 03 '17 at 19:04

score 3 · Accepted Answer · answered Apr 24 '15 at 11:38

3

This worked;

<Exec Command='sqlite3 "@(DeployedSqliteDbPath)" "DELETE FROM BatchConfig;"'/>

answered Apr 24 '15 at 11:38

Orson

1 Answers1