---

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