Using SQLite in your windows store application

Using SQLite in your windows store application

      Using SQLite in your windows store application

      hi!  i am going to introduce you how to use sqlite in windows store application (with C#)
      so first

     what's sqlite? 


     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 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:


   Create table




    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 :) !!! 

5 posts / 0 new
Last post
For more complete information about compiler optimizations, see our Optimization Notice.

What a nice tutorial chiheb c. I really like it because it shows how much easy it's to embed SQLite database in Windows 8 applications.

What a nice work chiheb c. I appreciate it because it shows how much easy it's to use SQLite in Windows 8 applications: a very simple installation managed by Nuget, then just some lines of code.

Hi, thank you! good input!

Leave a Comment

Please sign in to add a comment. Not a member? Join today