Local Storage (SQLite) Using Windows 10 UWP Apps

Local Storage (SQLite) Using Windows 10 UWP Apps

The Windows 10 Universal app local storage using SQLite database. Step-by-step implementation.

Step 1:

Create new universal project / library using VS2015 RTM Version

Step 2:

Install “sqlite-uap-3081101.VSIX “from Extensions and Updates
VS 2015 --Tools --Extensions and update --search sqlite-uap -- Click Install -- Restart VS 2015

Step 3:

The next step is to add the SQLite.Net-PCL library to your project

Step 4:

Now, remember the sqlite-uap (Visual Studio extension) installed earlier. It installs SQLite extensions that you need to reference by right-clicking on Project References and choosing "Add Reference..." and then finding the right reference under Windows Universal è Extensions.

Step 5:

Coding:

class LocalDatabase
{
public static void CreateDatabase()
{
var sqlpath = System.IO.Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "Contactdb.sqlite");
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), sqlpath))
{
conn.CreateTable();
}
}
}
public class Contact
{
public int Id { get; set; }
public string Name { get; set; }
public string Address { get; set; }
public string Mobile { get; set; }
}