---

using Dapper;

Dapper.DefaultTypeMap.MatchNamesWithUnderscores = true;
var connection = new SqliteConnection("DataSource=app.db");
var tasks = connection.Query<Task>("SELECT * FROM tasks");
foreach (Task task in tasks)
{
    Console.WriteLine($"#{task.Id} [{(task.Finished ? 'x' : ' ')}] {task.Title}");
}

connection.Execute("INSERT INTO tasks(title) VALUES (@Title)", new
{
    Title = "Адская задача888",
});
connection.Execute("UPDATE tasks SET finished = NOT finished WHERE id = @Id", new
{
    Id = 2,
});
connection.Execute("DELETE FROM tasks WHERE id = (SELECT id FROM tasks ORDER BY id DESC LIMIT 1)");