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

    

   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"/>

   Result:

        

   & Good Luck :) !!! 

5 post / 0 nuovi
Ultimo contenuto
Per informazioni complete sulle ottimizzazioni del compilatore, consultare l'Avviso sull'ottimizzazione

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!

JudLup Luna

Accedere per lasciare un commento.