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
});
}