Windows Store应用程序中的SQLite异常

本文关键字:SQLite 异常 Store 应用程序 Windows | 更新日期: 2023-09-27 18:13:13

在我的通用应用程序Windows 8.1(商店)和Windows Phone 8.1我有一个例外,只在商店应用程序中打开一个数据库。代码是共享的,对于Windows Phone它是工作的。

class MemoDB
{
    public static SQLiteConnection conn;
    public MemoDB() { 
        conn = LoadDatabase();
    }
    static private SQLiteConnection LoadDatabase()
    {
       // Get a reference to the SQLite database
       conn = new SQLiteConnection("ct_history.sqlite");
    ...
    }
}

异常{"无法设置临时目录。"}出现在最后显示的代码行,详细信息如下:

SQLitePCL.SQLiteException was not handled by user code.
  HResult=-2146233088
  Message=Unable to set temporary directory.
  Source=SQLitePCL
  StackTrace:
       at SQLitePCL.SQLiteConnection.SetTemporaryDirectory()
       at SQLitePCL.SQLiteConnection..ctor(String fileName, Boolean setTemporaryDirectory)
       at SQLitePCL.SQLiteConnection..ctor(String fileName)
       at CTDICT.MemoDB.LoadDatabase()
       at CTDICT.MemoDB..ctor()
       at CTDICT.Dictionary..ctor()
       at CTDICT.CTDICT_Windows_XamlTypeInfo.XamlTypeInfoProvider.Activate_8_Dictionary()
       at CTDICT.CTDICT_Windows_XamlTypeInfo.XamlUserType.ActivateInstance()
  InnerException: SQLitePCL.SQLiteException
       HResult=-2146233088
       Message=Unable to open the database file: :memory:
       Source=SQLitePCL
       StackTrace:
            at SQLitePCL.SQLiteConnection..ctor(String fileName, Boolean setTemporaryDirectory)
            at SQLitePCL.SQLiteConnection.SetTemporaryDirectory()
       InnerException: System.DllNotFoundException
            HResult=-2146233052
            Message=DLL "sqlite3.dll": The specified module could not be found. (Exception from HRESULT: 0x8007007E) can not be loaded.
            Source=SQLitePCL.Ext
            TypeName=""
            StackTrace:
                 at SQLitePCL.SQLite3Provider.NativeMethods.sqlite3_open(IntPtr filename, IntPtr& db)
                 at SQLitePCL.SQLite3Provider.Sqlite3Open(IntPtr filename, IntPtr& db)
                 at SQLitePCL.SQLiteConnection..ctor(String fileName, Boolean setTemporaryDirectory)
            InnerException: 

在我看来,"DLL sqlite3.dll:指定的模块找不到"是指向问题。我检查了路径"C:'Program Files (x86)'Microsoft sdk 'Windows'v8.1' extensionsdk 'SQLite.WinRT81'3.8.5'",发现DLL在所有配置(ARM, x64, x86)。

在Windows运行时(Windows 8.1)(版本3.8.5.0)和SQLitePCL (v4.0.30319)中正确设置SQLite引用

知道该怎么做吗?

Windows Store应用程序中的SQLite异常

即使我已经这样做了几次,我再次删除了Windows运行时(Windows 8.1)的参考。但是这次我也删除了Microsoft Visual c++ 2013 Runtime Package for Windows的参考。当我再次添加时,问题就解决了。