Загрузка данных


using Dapper;
using Microsoft.Data.Sqlite;
Dapper.DefaultTypeMap.MatchNamesWithUnderscores = true;

var connectionSting = "DataSource=app.db";

var connection = new SqliteConnection(connectionSting);


bool running = true;

var planet = connection.Query<Planet>("SELECT * FROM planets");
foreach(var i in planet)
{
    Console.WriteLine($"index_from_sun = {i.IndexFromSun}, Name = {i.Name}");
}
Console.WriteLine();