How can I make SQLite work on Windows 10?

c# sqlite windows-runtime winrt-xaml windows-10
user1930132 picture user1930132 · Feb 26, 2015 · Viewed 17.2k times · Source

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

Igor Ralic picture Igor Ralic · May 2, 2015

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.

Related questions

Class Property Not be included as sqlite database column

I have one entity class as public class someclass { public string property1 {get; set;} public string property2 {get; set;} public string property3 {get; set;} } and using sqlite connection class obj DB I am creating the table Db.CreateTableAsync<someclass&…

Read More
Create SQLite Database and table

Within C# application code, I would like to create and then interact with one or more SQLite databases. How do I initialize a new SQLite database file and open it for reading and writing? Following the database's creation, how do …

Read More
Unable to load DLL 'SQLite.Interop.dll'

Periodically I am getting the following exception: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) I am using 1.0.82.0. version, installing it with nuget in VS2010, OS Win7 64. Once exception …

Read More