public void UpdateOrInsert(Product product) { string query = $@"IF EXISTS (SELECT TOP 1 * FROM Prodcuts WHERE ProductID = {product.ID}) BEGIN UPDATE Products SET Name = '{product.Name}' SET [Single Price] = {product.SinglePrice} SET CategoryID = '{product.CategoryID}' WHERE ProductID = {product.ID} END ELSE BEGIN SET IDENTITY_INSERT Products ON INSERT INTO Products VALUES ({product.ID}, '{product.Name}', {product.SinglePrice}, '{product.CategoryID}') SET IDENTITY_INSERT Products OFF END"; ExecuteNonQuery(query); }
public void UpdateOrInsert(Product prod) { string query = $@"IF EXISTS (SELECT TOP 1 * FROM Products WHERE ProductID = {prod.Id}) BEGIN UPDATE Products SET Name = '{prod.Name}' SET Price = {prod.Price} SET Category = {prod.CategoryId} WHERE ProductID = {prod.Id} END ELSE BEGIN SET IDENTITY_INSERT Products ON INSERT INTO Products VALUES ({prod.Id}, '{prod.Name}', {prod.Price}, {prod.CategoryId}); SET IDENTITY_INSERT Products OFF END"; ExecuteNonQuery(query); }