public ActionResult Delete([FromRoute] int id) { var prod = _ctx.Products.Find(id); _ctx.Products.Remove(prod); _ctx.SaveChanges(); return(Ok()); }
public void Add(Employee employee) { using (var context = new AcmeDbContext()) { context.Employees.Add(employee); context.SaveChanges(); } }
public void Add(ApplicationUser applicationUser) { using (var context = new AcmeDbContext()) { context.ApplicationUsers.Add(applicationUser); context.SaveChanges(); } }
public bool SaveSignup(Signup signup) { var existingSignup = GetSignup(signup.SignupId); if (existingSignup == null) { var newSignupId = CreateSignup(signup); return(newSignupId > 0); } #region Here we may user AutoMapper existingSignup.Activity = signup.Activity; existingSignup.Comments = signup.Comments; existingSignup.User = signup.User; #endregion var retValue = _dbCtx.SaveChanges(); if (retValue == 0) { _dbCtx.Entry(signup).State = EntityState.Modified; } return(retValue == 0); }
public bool SaveUser(User user) { var existingUser = GetUser(user.Email); if (existingUser == null) { var newUserId = CreateUser(user); return(newUserId > 0); } #region Here we may user AutoMapper existingUser.FirstName = user.FirstName; existingUser.LastName = user.LastName; existingUser.Email = user.Email; #endregion var retValue = _dbCtx.SaveChanges(); if (retValue == 0) { _dbCtx.Entry(user).State = EntityState.Modified; } return(retValue == 0); }
public virtual void Insert(T entity) { try { if (entity == null) { throw new ArgumentNullException(nameof(entity)); } Entities.Add(entity); _context.SaveChanges(); } catch (InvalidOperationException dbEx) { //ensure that the detailed error text is saved in the Log throw new Exception(dbEx.Message); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new AcmeDbContext( serviceProvider.GetRequiredService < DbContextOptions <AcmeDbContext> >())) { if (context.Submission.Any()) { return; // DB has been seeded } for (int i = 0; i < 2; i++) { context.Submission.AddRange( new Submission { FullName = "Rasmus Paludan", Email = "*****@*****.**", Age = 47, SerialNum = 95676611 }, new Submission { FullName = "Kaj Boyesen", Email = "*****@*****.**", Age = 45, SerialNum = 32427143 }, new Submission { FullName = "Søren Malling", Email = "*****@*****.**", Age = 55, SerialNum = 59395710 }, new Submission { FullName = "Gordon Ramsey", Email = "*****@*****.**", Age = 50, SerialNum = 74457705 }, new Submission { FullName = "Morgan Freeman", Email = "*****@*****.**", Age = 100, SerialNum = 67800879 }, new Submission { FullName = "Kanye West", Email = "*****@*****.**", Age = 48, SerialNum = 65996900 }, new Submission { FullName = "Egon Olsen", Email = "*****@*****.**", Age = 90, SerialNum = 35581572 }, new Submission { FullName = "Casper Christensen", Email = "*****@*****.**", Age = 52, SerialNum = 88059526 }, new Submission { FullName = "Ole Thestrup", Email = "*****@*****.**", Age = 80, SerialNum = 93172768 }, new Submission { FullName = "Kim Larsen", Email = "*****@*****.**", Age = 63, SerialNum = 46632564 }, new Submission { FullName = "Margrethe II", Email = "majestæ[email protected]", Age = 80, SerialNum = 38875640 }, new Submission { FullName = "Mads Mikkelsen", Email = "*****@*****.**", Age = 54, SerialNum = 82514261 }, new Submission { FullName = "Nikolaj-Lie Kaas", Email = "*****@*****.**", Age = 46, SerialNum = 58079554 } ); context.SaveChanges(); } } }
public void Save() { _dbContext.SaveChanges(); }