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; }
}
|
