How can I make SQLite work on Windows 10?

Question

Yo,

So I've been developing a Universal Windows Store app in Visual Studio 2013 on one machine, and wanted to continue developing it on an another machine running Windows 10 Technical Preview.

The problem is that in Visual Studio 2015 Preview there is a new C++ Redistributable package version (2015), and the latest SQLite requires version 2013, so that particular reference is missing. I can build the project, it deploys successfully, but there is an exception saying it can't load sqlite3.dll. I'm assuming this is because of the missing Visual C++ Redistributable Package 2013. I tried downloading it, but the entry is still missing from the Add reference dialog under Extensions, where it is seen on VS 2013.

Any experience of making it work? Any insider info on when SQLite will work for Windows 10?

Cheers

Answer 1

Yesterday I blogged about how to get SQLite working with Windows 10 Universal apps

It's really simple and comes down to using a pre-release version of SQLite Visual Studio extension, and then just using whatever library or ORM you used before.

Note that Windows 10 Universal apps will also be capable of using Entity Framework 7, which can be used with almost any DB provider including SQLite.

EDIT: The Visual Studio extension is not in pre-release as of build 10240.

Answer 2

SQLite for Universal App Platform is now available as pre-release

Sqlite download page