CODEWITHSUNDEEP
c#sqliteportable-class-libraryclass-librarywin-universal-app
ckmk14
ckmk14

Reputation: 99

SQLite in an Universal App

I am developing an Universal App which should use SQLite. Additionally I want to store data into the database from a background task (Windows Runtime Component). Therefore I need to do my hole SQLite stuff in a ClassLibrary because of this thread. I also use sqlite-net.

Now I discovered that i need SQLite for Windows Runtime (Windows 8.1) and SQLite for Windows Phone. Or is there another extension which i can use for those two platforms instead?

If I need those two extensions i should create two ClassLibraries. Or am I wrong? One ClassLibrary where i install SQLite for Windows Phone and reference this library to my Windows Phone project and a second ClassLibrary where I install SQLite for Windows Runtime (Windows 8.1) and reference this library to my Windows Store Project or is there a better way??

Any help is welcome :)

Regards, Markus

Upvotes: 1

Views: 1078

Answers (3)

zirkelc
zirkelc

Reputation: 1723

Create one solution with three projects for Windows, Windows Phone, and the shared PCL. The SQLite extension will be added to the correspoding Windows and Windows Phone project. The whole SQL stuff like your tables/models will be added to your Portable Class Libary.

Upvotes: 0

Taras Seredokha
Taras Seredokha

Reputation: 372

SQLite now supports better way to work with Universal Application. Just download extension for Visual Studio 2015. https://visualstudiogallery.msdn.microsoft.com/4913e7d5-96c9-4dde-a1a1-69820d615936

This extension supports IOT too.

Upvotes: 1

mvermef
mvermef

Reputation: 3924

sqlite-net is c# code library that bridges the gap between the sqlite.dll which is exposed from the reference to assembly you indicated.

https://github.com/praeclarum/sqlite-net

Upvotes: 0

Related Questions