如何在MSBUILD的Exec任务中执行sqlite（sqlite3）语句？

Question

我正在尝试在构建应用程序后对sqlite数据库运行一些查询。

我尝试了以下方法;

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

并且

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

但是它似乎不起作用。有人能帮忙吗？

- Orson

---

请参考 https://dev59.com/U1TTa4cB1Zd3GeqPrVEJ。 - StayOnTarget

Answer 1

这个有效；

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

- Orson