---

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