---

using System.Data;
using Microsoft.Data.Sqlite;
using Dapper;

class User
{
    public required int Id;
    public required string Name;
}

class Program
{
    static void Main()
    {
        var connection = new SqliteConnection("DataSource=app.db");
        var users = connection.Query<User>("SELECT * FROM users");
        foreach (User user in users)
        {
            Console.WriteLine($"{user.Id}: {user.Name}");
        }
    }
}