public void Add(Game game) { //Determine the next ID var newID = _context.BoardGames.Select(x => x.ID).Max() + 1; game.ID = newID; _context.BoardGames.Add(game); _context.SaveChanges(); }
public IActionResult Add(BoardGame game) { //Determine the next ID var newID = _context.BoardGames.Select(x => x.ID).Max() + 1; game.ID = newID; _context.BoardGames.Add(game); _context.SaveChanges(); return(RedirectToAction("Index")); }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new BoardGamesDBContext(serviceProvider.GetRequiredService <DbContextOptions <BoardGamesDBContext> >())) { // Look for any board games already in database. if (context.BoardGames.Any()) { return; // Database has been seeded } context.BoardGames.AddRange( new BoardGame { ID = 1, Title = "Candy Land", PublishingCompany = "Hasbro", MinPlayers = 2, MaxPlayers = 4 }, new BoardGame { ID = 2, Title = "Sorry!", PublishingCompany = "Hasbro", MinPlayers = 2, MaxPlayers = 4 }, new BoardGame { ID = 3, Title = "Ticket to Ride", PublishingCompany = "Days of Wonder", MinPlayers = 2, MaxPlayers = 5 }, new BoardGame { ID = 4, Title = "The Settlers of Catan (Expanded)", PublishingCompany = "Catan Studio", MinPlayers = 2, MaxPlayers = 6 }, new BoardGame { ID = 5, Title = "Carcasonne", PublishingCompany = "Z-Man Games", MinPlayers = 2, MaxPlayers = 5 }, new BoardGame { ID = 6, Title = "Sequence", PublishingCompany = "Jax Games", MinPlayers = 2, MaxPlayers = 6 }); context.SaveChanges(); } }