Unable to load DLL sqlite3 in Universal Windows App running on Mobile

Question

I am developing a UWP. I am using the sqlite-net-pcl library. After upgrading my Application from RC to RTM , I got a runtime error - sqlite3.dll could not be found - if it runs on a Mobile emulator or a device. It worked prefectly after I added a reference to C++ 2013 Runtime Package and I ran it in Local Machine.

Exception Message:

Message "The type initializer for 'SQLitePCL.raw' threw an exception." string

The innerexception message:

{"Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"} System.Exception {System.DllNotFoundException}

Of course I could not add a referece to 'Sqlite for Universal App Platform' because I am geting the following error

Severity Code Description Project File Line Error Payload contains two or more files with the same destination path 'sqlite3.dll'. Source files: C:\Program Files (x86)\Microsoft SDKs\UAP\v0.8.0.0\ExtensionSDKs\SQLite.UAP.2015\3.8.11.1\Redist\Debug\ARM\sqlite3.dll C:\Users\sMavrikis.nuget\packages\SQLitePCL.raw_basic\0.7.1\build\native\sqlite3_dynamic\winrt81\arm\sqlite3.dll TestApp1

Pinchpenny

Answer 1

Add a reference to 'SQLite for Universal App Platform' This will trigger the error:

Payload contains two or more files with the same destination path 'sqlite3.dll'.

This error occurs because of different version of sqlite3.dll in both the locations marked by the error. Resolve this error by simply copying

C:\Program Files (x86)\Microsoft SDKs\UAP\v0.8.0.0\ExtensionSDKs\SQLite.UAP.2015\3.8.11.1\Redist\Debug\ARM\sqlite3.dll

to

C:\Users\%USERNAME%\.nuget\packages\SQLitePCL.raw_basic\0.7.1\build\native\sqlite3_dynamic\winrt81\arm\sqlite3.dll

overwriting existing file.

Rebuild your project. It should compile now.

Dynamoelectric

Thank you. It is help for me. I have a different way. It can be seen in the error message. – Runofthemill

As said above, you have to copy from and to the folders indicated in your own error (they were different for me). What made my app compile was to copy from program files to the package folder. Also note that this solution not always works (I tried it with two different apps and it only worked on one of them) – Calamine

This solved it for me thanks. Won't this be a problem for other people importing the project then? – Banister

Answer 2

If you look at the two conflicting locations, one seems to be coming from a more official Microsoft extension for UWP, while the second is coming from a nuGet package.

When I encountered this error, I needed the functionality of the nuGet package, so I decided to keep it and drop the other reference. I right clicked on the project in the solution explorer and went to Add->Reference and then unchecked the reference to SQLite. Seemed less error prone than copying the file from one location to the other to me.

Avilla

This answer helped me notice that I was referencing the Microsoft Visual C++ 2013 Runtime Package rather than the Visual C++ 2015 Runtime for Universal Windows package. Fixing the references fixed the problem for me. – Limb

Answer 3

I was getting the same error messages. I had started by using SQLite-PCL which also required SQLite for Universal App Platform as a reference. Later I switched to SQLite.Net-PCL. That is when I got those errors. In researching a solution I found this page. It worked for a bit. Eventually I removed the Reference to SQLite for Universal App Platform and the errors went away.

Transparent

Answer 4

late reply, but had the issue now; What fix it for me was to do Nuget Package update on all the project in the solution as one of the packages was still using the old reference and was pulling through to the Running project referencing the other project that was out of date.

Duntson

Answer 5

I fixed a similar issue by selecting x64 or arm in the compiler configuration.

Error Payload contains two or more files with the same destination path 'e_sqlite3.dll'. Source files: C:\Users\xleon.nuget\packages\SQLitePCLRaw.lib.e_sqlite3.v140\1.1.0\runtimes\win10-arm\native\e_sqlite3.dll C:\Users\xleon.nuget\packages\sqlitepclraw.lib.e_sqlite3.v140\1.1.0\runtimes\win10-x86\native\e_sqlite3.dll

but this, of course, won´t allow you to run the emulator

Septennial

Answer 6

Right-Click on the UWP Project and choose Properties.

And make sure the Solution Platform target matches the Project Platform target.

If they are different you will get the build error about copying files to the same destination with the same name (but different target platforms).

Kamilahkamillah

Answer 7

I managed to solve the disparity by putting a conditional in the UWP .csproj for including the SQLite dll

<SDKReference Include="SQLite.UWP.2015, Version=3.19.3" Condition="'$(Configuration)'=='Debug'">
  <Name>SQLite for Universal Windows Platform</Name>
</SDKReference>

I needed to run with the UWP version for debugging, else my XAMl designer would blow up with "Can't find SQLite.dll..."

Seraphine