using Microsoft.Data.Sqlite;

var conn = new SqliteConnection ("Data Source=hello.db");
conn.Open();

SqliteCommand cmd = conn.CreateCommand();
string sql = "select * from sampletable";
cmd.CommandText = sql;

SqliteDataReader reader = cmd.ExecuteReader();
while(reader.Read()) {
    Console.WriteLine($"{reader.GetString(0)} {reader.GetInt32(1)}");
}