Add SQLite-Net async support

[Guillermo Gutiérrez]

Currently all the SQLite-Net extension methods use the standard SQLite-Net methods, that are all synchronous. It would be good to add support for the increasingly popular SQLite-Net async library.

[Jeremy Kolb]

Has anyone tried to do this? I've tried to start a few times but am having some trouble as I'm not entirely familiar with writing async tasks.

[Jeremy Kolb]

I need some guidance on this. At the moment I'm trying to just implement async versions of the ReadOperations/WriteOperations public interface that act on an SQLiteAsyncConnection instead of SQLiteConnection. Then I'm hoping to somehow get the underlying sync connection and call into the private interface with locks. However getting the synchronous connection object from the async one seems tricky. Does this approach make sense?

The alternative is to just copy and paste ReadOperations and WriteOperations, change to SQLiteAsyncConnection everywhere and make almost everything async. I'm just nervous about keeping the two in-sync after that.

Any thoughts on how we want this to look? I don't have much experience using async/await so there may be a better way to do this.

[Guillermo Gutiérrez]

Merged pull request and deployed to NuGet: https://www.nuget.org/packages/SQLiteNetExtensions.Async/