//Update
public static void Update(AlifShop product)
{
using (IDbConnection con = new SqlConnection(ConnectionString))
{
con.Query <AlifShop>($"Update AlifShop SET Company='{product.Company}', Model='{product.Model}' WHERE ID={product.Id}");
}
}
//Delete
public static void Delete(AlifShop product)
{
using (IDbConnection con = new SqlConnection(ConnectionString))
{
con.Query <AlifShop>($"DELETE FROM AlifShop WHERE ID={product.Id}");
}
}
public static void Add(AlifShop product)
{
using (IDbConnection con = new SqlConnection(ConnectionString))
{
con.Query($"INSERT INTO AlifShop (Company, Model) Values('{product.Company}','{product.Model}')");
}
}