using System;

using SQLite;

using SQLiteNetExtensions;

​

public class SomeObject

{

    [PrimaryKey, AutoIncrement]

    public int Id {get;set;}

    public string Value {get;set;}

}

public class Program

{

    public static void Main()

    {

        SomeObject a = new() {Value = "object A"};

        SomeObject b = new() {Value = "object B"};

        SomeObject c = new() {Value = "object C"};

        var db = new SQLiteConnection("Data Source=:memory:");

        db.CreateTable<SomeObject>();

        Console.WriteLine("Values before Insert" + Environment.NewLine);

        Console.WriteLine($"Id: {a.Id}, Value {a.Value}");

        Console.WriteLine($"Id: {b.Id}, Value {b.Value}");

        Console.WriteLine($"Id: {c.Id}, Value {c.Value}");

        db.Insert(a);

        db.Insert(b);

        db.Insert(c);

​

        Console.WriteLine(Environment.NewLine);

        Console.WriteLine("Values after Insert" + Environment.NewLine);

        Console.WriteLine($"Id: {a.Id}, Value {a.Value}");

        Console.WriteLine($"Id: {b.Id}, Value {b.Value}");

        Console.WriteLine($"Id: {c.Id}, Value {c.Value}");

    }

}