This article introduces how to use SQLite in Windows Store applications (with C#).
SQLiteSQLite is a great SQL database engine. Actually it is the most widely deployed SQL database engine in the world!This useful database engine is available as an extension to Visual Studio.How to install SQLiteGo to the “tools” menu and choose “Extensions and Updates”.Choose the “Online” section, search for “SQLite” then download and install “SQLite for Windows Runtime”.Add the following reference to your project:SQLite for Windows Runtime.Microsoft Visual C++ Runtime Package. Now we see Yellow marks, so what's the solution?You need to choose and build a specific architecture (x86, x64 or ARM) as in the following:Finally, the last step.You need to install the Nuget sqlite.net (to call the SQLite APIs).This will add the 2 files to your solution SQLite.cs and SQLiteAsync.cs.Now, you're ready to use SQLite in your application!Let's create a connection to the database.Create tableFinally create a ListView in MainPage.xaml and name it people as in the following:
Printing in C# Made Easy