Does the sqlite-net async API support dispose?

I had the exact same problem in case where database was supposed to be sent via email for debugging/analyzing purposes. There was no way of doing that because connection is held.

You can go around this by modifying the sqlite-net implementation a bit.

On top of SQLiteAsync.cs add following partial class declaration.

namespace SQLite
{
    public partial class SQLiteAsyncConnection
    {
        public void ResetConnections()
        {
            SQLiteConnectionPool.Shared.Reset();
        }
    }
}

and then change access modifier of above Reset method as public.

In your application code just call <YourSQLiteAsyncConnection>.ResetConnections(); before deleting the DB file.

---

Then again, when testing you could create your database in memory so you don't have to delete it at all. You can achieve this by setting DatabasePath as ":memory:".

On November 23rd 2015 they added a static method that does what Mikko Viitala suggested, So I just put the following in my dispose method.

SQLiteAsyncConnection.ResetPool();