public static void Initialize(IServiceProvider serviceProvider) { using (var context = new MovieContext( serviceProvider.GetRequiredService <DbContextOptions <MovieContext> >())) { // Look for any movies. if (context.Movie.Any()) { return; // DB has been seeded } context.Movie.AddRange( new Movie { Title = "When Harry Met Sally", ReleaseDate = DateTime.Parse("1989-2-12"), Genre = "Romantic Comedy", Price = 7.99M, Rating = "R" }, new Movie { Title = "Ghostbusters", ReleaseDate = DateTime.Parse("1984-3-13"), Genre = "Comedy", Price = 8.99M, Rating = "R" }, new Movie { Title = "Ghostbusters 2", ReleaseDate = DateTime.Parse("1986-2-23"), Genre = "Comedy", Price = 9.99M, Rating = "R" }, new Movie { Title = "Rio Bravo", ReleaseDate = DateTime.Parse("1959-4-15"), Genre = "Western", Price = 3.99M, Rating = "R" } ); context.SaveChanges(); if (context.Movie.Any()) { return; // DB has been seeded. } } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new MovieContext( serviceProvider.GetRequiredService <DbContextOptions <MovieContext> >())) { if (context.Movies.Any()) { return; } context.Movies.AddRange ( new Movie { Title = "Breaking bad", Genre = "Criminal", ReleaseDate = DateTime.Parse("12.02.2007"), Price = 7.99M, Rating = "R" }, new Movie { Title = "Prison Break", Genre = "Criminal", ReleaseDate = DateTime.Parse("12.10.2005"), Price = 7.99M, Rating = "B" }, new Movie { Title = "MD House", Genre = "Detective", ReleaseDate = DateTime.Parse("03.02.2003"), Price = 7.99M, Rating = "A" }, new Movie { Title = "Scrubs", Genre = "Comedy", ReleaseDate = DateTime.Parse("12.02.2010"), Price = 5.99M, Rating = "S" } ); context.SaveChanges(); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new MovieContext( serviceProvider.GetRequiredService<DbContextOptions<MovieContext>>())) { // Look for any movies. if (context.Movie.Any()) { return; // DB has been seeded } context.Movie.AddRange( new Movie { Title = "The Shawshank Redemption", ReleaseDate = DateTime.Parse("1994-10-14"), Genre = "Drama", Price = 17.99M, Rating = "R" }, new Movie { Title = "The Godfather", ReleaseDate = DateTime.Parse("1972-3-24"), Genre = "Crime", Price = 16.99M, Rating = "R" }, new Movie { Title = "The Godfather: Part II", ReleaseDate = DateTime.Parse("1974-12-20"), Genre = "Drama", Price = 16.99M, Rating = "R" }, new Movie { Title = "The Dark Knight", ReleaseDate = DateTime.Parse("2008-7-18"), Genre = "Action", Price = 12.99M, Rating = "PG-13" }, new Movie { Title = "12 Angry Men", ReleaseDate = DateTime.Parse("1957-04-01"), Genre = "Crime", Price = 13.99M, Rating = "Approved" }, new Movie { Title = "Schindler's List", ReleaseDate = DateTime.Parse("1994-02-04"), Genre = "Biography", Price = 12.99M, Rating = "R" }, new Movie { Title = "The Lord of the Rings: The Return of the King", ReleaseDate = DateTime.Parse("2003-12-17"), Genre = "Adventure", Price = 12.99M, Rating = "PG-13" } // New Movie Template, Uncomment and Fill in Values //, //new Movie //{ // Title = "T", // ReleaseDate = DateTime.Parse("2000-01-01"), // Genre = "G", // Price = 00.00M, // Rating = "R" //} ); context.SaveChanges(); } }