SQLite on IOT

Question

I have a problem getting a library used on the Raspberry PI to work with SQLite.

I created a Universal WIndows App, it has no problem running on the Pi.

I also created a Portable Library, it references

SQLite.NET

SQLite.NET.Async

SQLite.NET.Platform.WinRT

This library is refrerenced by the App

Creating the SQLite database results in a DLL not found exception, which I figured must be the sqlite3.dll for ARM. But both the portable classlibary (only allows Any CPU) and the universal app (set to ARM in the configuration) wont allow the reference to SQlite3.dll

What am I doing wrong?

Thanks

Ben

Answer 1

Andy Wigley is the go to guy for SQLite on the IoT Pi. There is a link to his stuff on the Unofficial FAQ over on the Raspberry site that I maintain. It's also on Channel 9 in you look and his blog.

---

riclh

Answer 2

Thanks

He indeed got the same error, did not want to find out what was causing it and wrote his own.. unfortunately on a pre RTM version of visual studio, so I still haven't found a solution. Could not get his code to work either,

Answer 3

Have you tried the code on Github? https://gist.github.com/ChrisBriggsy/f08aae8a7aa48b1b2dc5

Answer 4

http://igrali.com/2015/05/01/using-sqlite-in-windows-10-universal-apps/ if you need help to install it

Answer 5

Did you install SQLite? This brings the missing dll to the Windows extensions.
You can get it from here. Here is a good explanation.

If all this is done, you can add a reference to SQLite for Universal App Platform, which is the missing dll.