---

public static class Database {
    static Database() { Dapper.DefaultTypeMap.MatchNamesWithUnderscores = true; }
    static SqliteConnection connection = new SqliteConnection("DataSource=app.db");

    public static List<PowerBank> GetPowerBanks() {
        var powerBanks = connection.Query<PowerBank, Model, Point, PowerBank>(
            @"SELECT * FROM power_banks 
            INNER JOIN models ON models.id = power_banks.model_id
            INNER JOIN points ON points.id = power_banks.point_id", 
            (pb, model, point) =>
            {
                pb.Model = model;
                pb.Point = point;
                return pb;
            }
        );
        return powerBanks.ToList();
    }
}