---

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

while (true)
{
    Console.WriteLine("Add task");
    Console.WriteLine("delete task");
    Console.WriteLine("pin completed");
    Console.WriteLine("nafig");

    var command = Convert.ToInt32(Console.ReadLine());
    switch (command)
    {
        case 1:
            break;
        case 2:
            break;
        case 3:
            break;
        case 4:
            break;
        default:
            break;
    }
}