public static void Main()
{
var context = new MoviesEntities();
// Query 1.Adult Movies:
var adultMovies = context.Movies
.Where(m => m.AgeRestriction == AgeRestriction.Adult)
.OrderBy(m => m.Title)
.ThenByDescending(m => m.Ratings.Count)
.Select(m => new
{
title = m.Title,
ratingsGiven = m.Ratings.Count
});
string adultMoviesJson = JsonConvert.SerializeObject(adultMovies, Formatting.Indented);
File.WriteAllText("../../adult-movies.json", adultMoviesJson);
// Query 2.Rated Movies by User:
var ratedMoviesByUser = context.Users
.Where(u => u.Username == "jmeyery")
.Select(u => new
{
username = u.Username,
ratedMovies = u.Ratings
.OrderBy(r => r.Movie.Title)
.Select(r => new
{
title = r.Movie.Title,
userRating = r.Stars,
averageRating = r.Movie.Ratings.Average(rStars => rStars.Stars)
})
});
string ratedMoviesByUserJson = JsonConvert.SerializeObject(ratedMoviesByUser, Formatting.Indented);
File.WriteAllText("../../rated-movies-by-jmeyery.json", ratedMoviesByUserJson);
// Query 3.Top 10 Favourite Movies:
var favouriteMovies = context.Movies
.Where(m => m.AgeRestriction == AgeRestriction.Teen)
.OrderByDescending(m => m.UsersThatMovieIsFavourite.Count)
.ThenBy(m => m.Title)
.Take(10)
.Select(m => new
{
isbn = m.Isbn,
title = m.Title,
favouritedBy = m.UsersThatMovieIsFavourite.Select(u => u.Username)
});
string favouriteMoviesJson = JsonConvert.SerializeObject(favouriteMovies, Formatting.Indented);
File.WriteAllText("../../top-10-favourite-movies.json", favouriteMoviesJson);
}
public static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<MoviesEntities, MoviesConfiguration>());
var context = new MoviesEntities();
var moviesCount = context.Movies.Count();
}
