Загрузка данных


public class TodoList
{
    public static void AddTaskCommand(SqliteConnection connection)
    {
        connection.Execute("INSERT INTO tasks(title) VALUES (@Title)", new
        {
            Title = "Адская задача888",
        });
    }

    public static void RemoveTaskCommand(SqliteConnection connection)
    {
        connection.Execute("DELETE FROM tasks WHERE id = (SELECT id FROM tasks ORDER BY id DESC LIMIT 1)");
    }

    public static void SetFinishedTaskCommand(SqliteConnection connection)
    {
        connection.Execute("UPDATE tasks SET finished = NOT finished WHERE id = @Id", new
        {
            Id = 2,
        });
    }
}