public void GenreDropDownList(BasicoWebRazorCoreContext _context,
object selectedGenre = null)
{
IQueryable <Genre> genreQuery = from g in _context.Genre
orderby g.Name
select g;
GenreList = new SelectList(genreQuery.AsNoTracking(), "ID", "Name", selectedGenre);
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new BasicoWebRazorCoreContext(
serviceProvider.GetRequiredService <
DbContextOptions <BasicoWebRazorCoreContext> >()))
{
// Look for any movies.
if (context.Movie.Any())
{
return; // DB has been seeded
}
Genre genreTerror = new Genre {
Name = "Terror"
};
Genre genreAction = new Genre {
Name = "Action"
};
Genre genreLove = new Genre {
Name = "Love"
};
context.Genre.AddRange(
genreTerror,
genreAction,
genreLove
);
context.Movie.AddRange(
new Movie
{
Title = "When Harry Met Sally",
ReleaseDate = DateTime.Parse("1989-2-12"),
Genre = genreTerror,
Price = 7.99M,
Rating = "PG-3"
},
new Movie
{
Title = "Ghostbusters ",
ReleaseDate = DateTime.Parse("1984-3-13"),
Genre = genreAction,
Price = 8.99M,
Rating = "PG-13"
},
new Movie
{
Title = "Ghostbusters 2",
ReleaseDate = DateTime.Parse("1986-2-23"),
Genre = genreAction,
Price = 9.99M,
Rating = "PG-13"
},
new Movie
{
Title = "Rio Bravo",
ReleaseDate = DateTime.Parse("1959-4-15"),
Genre = genreLove,
Price = 3.99M,
Rating = "PG-18"
}
);
context.SaveChanges();
}
}
