How to unlock Sqlite Database after delete

Question

It seems the SQLite Database is locked when I do a delete operation as below:

And I need to delete two times in order to refresh. What is the normal way to delete without any locking by the Sqlite Database?

    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;


--- solution

private async Task<bool> DelTransactionLine(int PassInTransId)
 {


 //--1-- delete the selected transaction line
var ThisTrans = await db.QueryAsync<TransactionLine>("Select * From TransactionLine Where  Tid = '" + PassInTransId + "'");

   foreach (var line in ThisTrans)
  {
    var intDelStatus = await db.DeleteAsync(line);
   }

 return true;


 }

I don't know how SQLite works, but I have a couple of ideas. Could it be that the DeleteAsync is not done when you call it again? Is there a sync Delete? Try with a Thread.Sleep right after calling the DeleteAsync to see if that's it — sebagomez
– sebagomez, Commented Jan 28, 2014 at 15:55

TylerD87 · Accepted Answer · 2014-01-28 16:20:33Z

1

Can you do something like:

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

To await the delete operation returning before you try and delete the next one?

answered Jan 28, 2014 at 16:20

TylerD87

1,61813 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MilkBottle Over a year ago

I need to use Task<t> for this Delete function. Call this Task<t> base function will solve my problem.

MilkBottle Over a year ago

Forget to add : Use Function base on Task<> and your suggestion of await keyword. Thanks

Collectives™ on Stack Overflow

How to unlock Sqlite Database after delete

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related