//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}')"); } }