---

using Dapper;
using Dapper.Transaction;
using Microsoft.Data.Sqlite;
var connection = new SqliteConnection("DataSource=app.db");
var cities = connection.Query<City, Country, City>(
    "SELECT * FROM cities INNER JOIN countries ON countries.id = cities.country_id",
    (city, country) =>
    {
        city.Country = country;
        return city;
    }
);
foreach (var city in cities)
{
    Console.WriteLine($"Город {city.Name} (население {city.Population}) из страны {city.Country.Name}");
}