---

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

var connectionSting = "DataSource=app.db";

var connection = new SqliteConnection(connectionSting);


bool running = true;

while (running)
{
    Console.WriteLine("1. Вывести все бренды");
    Console.WriteLine("2. Вывести все напитки");
    Console.WriteLine("3. Вывести напитки бренда");
    Console.WriteLine("4. Закрыть программу");

     string? input = Console.ReadLine();

    switch (input)
    {
        case "1":
            var brend = connection.Query<Brand>("SELECT name FROM brands");
            foreach(var i in brend)
            {
                Console.WriteLine($"Name_Brand = {i.Name}");
            }
            Console.WriteLine();
            break;
        
        case "2":
            var drink = connection.Query<Drink>("SELECT * FROM drinks");
            foreach(var i in drink)
            {
                Console.WriteLine($"id = {i.Id}, Name = {i.Name}, BrandId = {i.BrandId}");
            }
            break;

        case "4":
            running = false;
            break;
    }
}