Skip to content
Branch: master
Find file History
Latest commit d0ef8a5 Mar 12, 2018
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
CreateDatabaseWithSqliteNet reorganizing files into recipes folder Mar 7, 2018
Images reorganizing files into recipes folder Mar 7, 2018
CreateDatabaseWithSqliteNet.sln reorganizing files into recipes folder Mar 7, 2018
README.md fixing broken links Mar 12, 2018

README.md

id title brief
9A6AF59E-BAEE-03B3-03A4-94A235C27CBF
Create a Database with SQLiteNET
This recipe will demonstrate how to create an SQLite database with SQLite-NET.

Recipe

The following recipe provide some sample code for using SQLite-NET to create a database with a single table and then inserting rows into that table, highlighting the relevant parts.

  1. Create a new Xamarin.iOS application called CreateDatabaseWithSqlitenet.
  1. Add a reference to System.Data and Mono.Data.SQLite
  1. Add the Nuget package sqlite-net by Frank Krueger to your project by right-clicking on the Packages folder and selecting Add Packages. In the window that opens, search for SQLite.Net, select the package and click *Add Package*.
[![](Images/nuget_install.png)](Images/nuget_install_big.png) ![](Images/nuget_result.png)
  1. Create a Person class that will represent a row inside an SQLite table named Person table:
public class Person
{
   [PrimaryKey, AutoIncrement]
   public int ID { get; set; }
   public string FirstName { get; set; }
   public string LastName { get; set; }
}

SQLite-NET will create a table that will hold a Person object, with columns in the table for each of the properties in the Person class. The ID property of the class is adorned with the attributes PrimaryKey and AutoIncrement. These attributes are by SQLite-NET to generate the proper DDL statements to create the Person table.

  1. The snippet for creating the database with a Person table can be see in the file CreateDatabaseWithSqliteNet.cs, lines 82-85:
using (var conn= new SQLite.SQLiteConnection(_pathToDatabase))
{
   conn.CreateTable<Person>();
}
  1. The code for inserting a new Person row into the person table can be the file CreateDatabaseWithSqliteNet.cs, lines 98-102:
var person = new Person { FirstName = "John " + DateTime.Now.Ticks, LastName = "Doe"};
using (var db = new SQLite.SQLiteConnection(_pathToDatabase ))
{
    db.Insert(person);
}
  1. Run the application. First click on the Create Database button to create the database and the schema:

  1. Now each time the Insert User button is clicked, another row is added to the Person table:

You can’t perform that action at this time.