UWP sqlite-net 异步数据库访问

在我的 UWP 应用中，我使用

解决方案

您需要同时安装 SQLite.Net.Async-PCL 和 SQLite.Net-PCL 使用异步操作.

SQLiteConnectionString connString = new SQLiteConnectionString(file.Path, true);var asyncConnction = new SQLiteAsyncConnection(() =>{返回新的 SQLiteConnectionWithLock(new SQLitePlatformWinRT(), connString);});

请注意，SQLite.Net-PCL 软件包与您安装的软件包不同.我不确定异步包是否与那个兼容.

On my UWP app, I'm using sqlite-net to access the database. According to their GitHub Page I'm using Source Installation. Now I want to migrate to using the Nuget package (To get the latest updates) and they have mentioned getting the PCL package. When I add the PCL package I don't have Async operations available like it was on Source Installation. Please let me know how to proceed on this matter.

When it comes to UWP and I want to use sqlite-net I see soo many nugets in VS 2015 Nuget Package Manager. Please help me which one to choose. (Selected package should not be deprecated in the near future and should be developed actively by the vendor, providing continues updates)

解决方案

You need to install both SQLite.Net.Async-PCL and SQLite.Net-PCL to use async operations.

SQLiteConnectionString connString = new SQLiteConnectionString(file.Path, true);
var asyncConnction = new SQLiteAsyncConnection(
    () => {
        return new SQLiteConnectionWithLock(new SQLitePlatformWinRT(), connString);
    }
);

Note that the SQLite.Net-PCL package is different from the one you installed. I'm not sure if the async package is compatible with that one.