c# - 如何在删除后解锁Sqlite数据库

Question

当我执行如下删除操作时，SQLite 数据库似乎被锁定:

而且我需要删除两次才能刷新。在没有 Sqlite 数据库任何锁定的情况下删除的正常方法是什么？

    var ThisTrans = await db.QueryAsync<TransactionLine>("Select * From TransactionLine Where  Tid = '" + PassInTransId + "'");    foreach (var line in ThisTrans)    {        var intDelStatus = db.DeleteAsync(line);    }    //- can  I use this to close Connection?? but it does not work!    db = null;--- solutionprivate async Task<bool> DelTransactionLine(int PassInTransId) { //--1-- delete the selected transaction linevar ThisTrans = await db.QueryAsync<TransactionLine>("Select * From TransactionLine Where  Tid = '" + PassInTransId + "'");   foreach (var line in ThisTrans)  {    var intDelStatus = await db.DeleteAsync(line);   } return true; }

Answer 1

你能做这样的事情吗:

var ThisTrans = await db.QueryAsync<TransactionLine>("Select * From TransactionLine    Where  Tid = '" + PassInTransId + "'");
foreach (var line in ThisTrans)
{
    var intDelStatus = await db.DeleteAsync(line);
}

要等待删除操作返回，然后再尝试删除下一个操作吗？