Using SQLite in your windows store application
hi! i am going to introduce you how to use sqlite in windows store application (with C#)
sqlite 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 sqlite?
Go to the "tools" menu and choose “Extensions and Update”:
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 notice a yellow marks what's the solution ?
you need to choose & build specific architecture (x86, x64 or ARM):
Finally, the last step
you need to install the Nuget sqlite.net(to call the SQLite APIs)
This will add 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:
now create a Listview in MainPage.xaml & name it people
<ListView x:Name="people" HorizontalAlignment="Left" Height="425" Margin="185,211,0,0" VerticalAlignment="Top" Width="394" Header="people"/>
& Good Luck :) !!!