SQLite CRUD Operation In WinJS: Windows Apps

As we know, WinJS applications are built using HTML/JS/CSS. And for a complete application, we will need async operations like sqlite database operations, web-service calls, and other native XML read-write, and File read-write which cannot be done directly in WinJS applications.

So we have to use Windows Runtime Component to access Native C# methods as discussed in my previous article: WinJS application with Windows Runtime Component to access native C# code.

For SQLite operation, we have to use Class Library.

Step 1

Firstly create a WinJS project.

Step 2

We need to do following things as discussed in my previous blog. Please have a look at my previous article.

• Add a Windows Runtime Component project and name it ‘WinRuntimes’
• Delete default class ‘Class1.cs’
• Add a new class and name it ‘Service’
• Add WinRuntimes reference in WinJS project
• Build the project

Step 3

After you are done with adding Runtime Component, we have to add Class Library for SQLite.

Click File, Add, New Project, Visual C#, Windows, Class Library (Windows 8.1). Name it SQLiteLibrary and click OK.



Step 4

Now we have to add a reference ’SQLite for Windows Runtime’ and ‘sqlite-net’ in Class Library. For this, Right Click on Reference and Manage Nuget Packages



From the Nuget package manager, we have to install two things:

• sqlite-net
• SQLite for Windows Runtime (Alternatively, you can download this from here.Install it and restart Visual Studio)
  
  
  
  
  

Step 5

After downloading and installing sqlite libraries, we have to add reference in Class Library:



Step 6

We need to change the Build Configuration to x86.

Go to Build > Configuration Menu and change Any CPU to x86 inside Active solution platform.



Step 7

In WinRuntimes project, right click on References and Add project SQLiteLibray as reference.



Step 8

Now in the WinJS (SQLiteOperations) project add reference of WinRuntimes. Right Click on References and add WinRuntimes as reference.



Step 9

Add a script.js file and reference it in default.html:

Now in default.html, lets add following things:

• Button to create a database
• Button to insert into database
• Two input fields to insert data into database
• Button to read from database
• Button to update
• Button to delete

Complete HTML code:

Step 10

We add a Database class in WinRuntimes project and we write all our CRUD operations code where we have respective IAsyncOperation for Create, Read, Update, Insert and Delete operations.

Creating Database