public void Delete(FoodOrder foodOrder) { using (IDbConnection db = new SqlConnection(connectionString)) { var sqlQuery = "DELETE FROM FoodOrders WHERE Id = @Id"; db.Execute(sqlQuery, foodOrder); } }
public void Update(FoodOrder foodOrder) { using (IDbConnection db = new SqlConnection(connectionString)) { var sqlQuery = "UPDATE FoodOrders SET DishName = @DishName, Count = @Count WHERE Id = @Id"; db.Execute(sqlQuery, foodOrder); } }
public void Create(FoodOrder foodOrder) { using (IDbConnection dbConnection = new SqlConnection(connectionString)) { var sqlQuery = "INSERT INTO FoodOrders (DishName, Count) VALUES(@DishName, @Count); SELECT CAST(SCOPE_IDENTITY() as int)"; int orderId = dbConnection.Query <int>(sqlQuery, foodOrder).FirstOrDefault(); foodOrder.Id = orderId; } }
public FoodOrder Get(int?id) { FoodOrder foodOrder = null; using (IDbConnection dbConnection = new SqlConnection(connectionString)) { foodOrder = dbConnection.Query <FoodOrder>("SELECT * FROM FoodOrders f WHERE f.Id = @id", new { id }).FirstOrDefault(); } return(foodOrder); }
public void Delete(FoodOrder foodOrder) { foodContext.Entry(foodOrder).State = EntityState.Deleted; foodContext.SaveChanges(); }
public void Update(FoodOrder foodOrder) { foodContext.Entry(foodOrder).State = EntityState.Modified; foodContext.SaveChanges(); }
public void Create(FoodOrder foodOrder) { foodContext.Entry(foodOrder).State = EntityState.Added; foodContext.SaveChanges(); }