Unable to load DLL 'sqlite3' - for Windows Universal Mobile

3
votes

I used Visual Studio 2015 with SP2. I try created Windows Universal app with sqlite. I added SQLite for Unversal Windows Platforms and SQLite.Net-PCl. It is my simple code

var conn = new SQLiteConnection(
            new SQLitePlatformWinRT(),
            Path.Combine(ApplicationData.Current.LocalFolder.Path,  "Storage.sqlite"));

It is working for desktop. But it is not work for mobile(in device and emulator). I get this exception System.DllNotFoundException:

  HResult=-2146233052
  Message=Unable to load DLL 'sqlite3': The specified module could not be  found. (Exception from HRESULT: 0x8007007E)
Source=SQLite.Net.Platform.WinRT
TypeName=""
StackTrace:
   at SQLite.Net.Platform.WinRT.SQLite3.SetDirectory(UInt32 directoryType, String directoryPath)
   at SQLite.Net.Platform.WinRT.SQLiteApiWinRT..ctor()
   at SQLite.Net.Platform.WinRT.SQLitePlatformWinRT..ctor()
   at AppDbTest.MainPage.DbConnection()
   at AppDbTest.MainPage..ctor()
   at AppDbTest.AppDbTest_XamlTypeInfo.XamlTypeInfoProvider.Activate_0_MainPage()
   at AppDbTest.AppDbTest_XamlTypeInfo.XamlUserType.ActivateInstance()

I try this method. I reinstall SQLite for Unversal Windows Platforms extension and SQLite.Net-PCl. I created clear project. But it does not work for me.

3
sqlitevisual-studio-2015windows-phonewin-universal-appsqlite-net
Did you try updating your nuget packages for new sqlite version? - Jerin
I use SQLite.Net-PCL 3.1.1 and SQLite.Net.Async-PCL 3.1.1. It is last version. - FetFrumos
For SQLite.Net.Async-PCL I am using 3.0.5 as 3.1.1 popped up some bug, in my project other than that my project works fine on all three desktop, mobile and emulator. Is it occurring in only current project or in every other project? - Jerin
This problem in the first working project. I created clear windows universal project - but I have this problem - FetFrumos
Since the problem might be in your current working environment or else some reference you have made could you share a sample app with the same error. - Jerin

3 Answers

10
votes

I add a reference to Visual C++ 2015 Runtime for Universal Windows Platform Apps. It is work for me. I used SQLite for Universal Windows Platform.

5
votes

Make sure that you current add 2 references

  1. Sqlite for Universal Windows Platfrom
  2. Visual C++ Runtime 2015 for Unversal Windows Platfrom

It's still worked!

0
votes

Solved in chat.
OP solved it using Nuget console : Install-Package SQLite.WinRT.UAP and used "add link" ->"Extensions"->SQLite for Windows Runtime
Suggestion
Cool but would suggest you to use Extension SQLite for Universal App Platform as it encases most of device family and SQLite.WinRT.UAP is not needed. As in current repo I removed references for Winrt and using these extensions its working fine. Just check if the Sqlite vsix package installed is the correct one on your system.