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?

Answer 1

This worked;

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