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

3

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.

sqlite
visual-studio-2015
windows-phone
win-universal-app
sqlite-net
asked on Stack Overflow Apr 1, 2016 by FetFrumos • edited Oct 12, 2018 by halfer

3 Answers

10

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.

answered on Stack Overflow Apr 11, 2016 by FetFrumos
5

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!

answered on Stack Overflow Apr 22, 2016 by Nguyên Phạm
0

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.

answered on Stack Overflow Apr 2, 2016 by Jerin

User contributions licensed under CC BY-SA 3.0