Xamarin Forms - System.Data.Sqlite

Question

I have a project that uses the NuGet package System.Data.Sqlite for accessing the DB.

At compile time all works fine, but at runtime when I initialize the connection this error occurs:

System.DllNotFoundException: SQLite.Interop.dll

I have tried to install the NuGet package System.Data.SQLite.Core but nothing changed.

This error occurs only in Android and iOS device, on UWP all works fine.

How can I solve this?

Anyone has find this error too?

Here a sample project.

Thank you!

Edit:

In that post proposed as solution the package used is sqlite-net-pcl, I use a different package, the System.Data.Sqlite.

Edit 2:

Possible duplicate of System.DllNotFoundException: /system/lib/libsqlite.so- Xamarin Forms — FreakyAli
– FreakyAli, Commented Apr 4, 2019 at 8:03
Hi, in that post the package used is sqlite-net-pcl, I use a different package, the System.Data.Sqlite. — Hikari
– Hikari, Commented Apr 4, 2019 at 8:14

Hikari · Accepted Answer · 2019-04-04 14:25:02Z

0

answered Apr 4, 2019 at 14:25

Hikari

5997 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Here's a link explaining the difference between: System.Data.SQLite and Microsoft.Data.Sqlite (also mentions Mono.Data.Sqlite) learn.microsoft.com/en-us/dotnet/standard/data/sqlite/compare

Here are some more interesting links about Microsoft.Data.Sqlite. Interoperability with the native SQLite library (uses SQLitePCLRaw): learn.microsoft.com/en-us/dotnet/standard/data/sqlite/interop