sqliteinsert.cs

public sealed partial class MainPage : Page
    {
        public MainPage()
        {
            this.InitializeComponent();
            Loaded += MainPage_Loaded;
        }

        void MainPage_Loaded(object sender, RoutedEventArgs e)
        {
            var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "foo.db");
            using (var db = new SQLiteConnection(path, true))
            {
                db.DropTable<Person>();

                db.CreateTable<Person>();

                db.Insert(new Person() { FirstName = "Tim", LastName = "Heuer" });
                db.Insert(new Person() { FirstName = "Zane", LastName = "Heuer" });
            }
        }
    }


    public class Person
    {
        [PrimaryKey,AutoIncrement]
        public int ID { get; set; }

        public string FirstName { get; set; }
        public string LastName { get; set; }
    }