private void UpdateConsume(LastConsume consume, Drink drink, int sugarLevel, bool usedMug) { consume.Drink1 = drink; consume.Drink = drink.Id; consume.SugarLevel = sugarLevel; consume.UseMug = usedMug; using (var dbContextTransaction = Context.Database.BeginTransaction()) { var query = Context.LastConsume.Add(consume); Context.SaveChanges(); dbContextTransaction.Commit(); } }
private void CreateConsume(Drink drink, string uid, int sugarLevel, bool usedMug) { var consume = new LastConsume() { Uid = uid, Drink = drink.Id, Drink1 = drink, SugarLevel = sugarLevel, UseMug = usedMug, }; using (var dbContextTransaction = Context.Database.BeginTransaction()) { var query = Context.LastConsume.Add(consume); try { // Your code... // Could also be before try if you know the exception occurs in SaveChanges Context.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { _logger.Log(LogLevel.Error, "Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { _logger.Log(LogLevel.Error, "- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } dbContextTransaction.Commit(); } }