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


using Dapper;
using Microsoft.Data.Sqlite;
Dapper.DeffaultTypeMap.MatchNameWithUnderscores = true;
var connection = new SqliteConnection("DataSource=app.db");
var brands = connection.Query<Brand>("SELECT * FROM  brands ");
foreach (Brand brand in brands)
{
    Console.WriteLine($"{brand.Id} {brand.Title} {brand.CompanyAdress} {brand.CompanyName}");
}

var clothes = connection.Query<Cloth>("SELECT * FROM clothes");
foreach (Cloth cloth in clothes)

for (int i = 1; i <= 10; i++) {
    Console.Write("введите название бренда: ");
    var title = Console ReadLine();
    Console Write("введите название компании: ");
    var companyName = Console ReadLine();
    Console Write("введите адрес компании: ");
    var companyAdress = Console ReadLine();
    connection.Execute("INSERT INTO brands(title, company_name, company_adress) VALUES(@Title, @companyName, @CompanyAdress)", new {
        Title = title, CompanyName = companyName, CompanyAdress = companyAdress
    });
}