static void Main(string[] args) { var context = new MovieContext(); var adultMovies = context.Movies .OrderBy(m => m.Title) .ThenBy(m => m.Ratings.Count) .Where(m => m.AgeRestriction == AgeRestriction.Adult) .Select(m => new { title = m.Title, ratingsGiven = m.Ratings.Count }); var json = new JavaScriptSerializer().Serialize(adultMovies); File.WriteAllText(@"adult-movies.json", json); }
static void Main(string[] args) { var context = new MovieContext(); var topTenFavoriteTeenMovies = context.Movies .Where(m => m.AgeRestriction == AgeRestriction.Teen) .OrderByDescending(m => m.Users.Count) .ThenBy(m => m.Title) .Select(m => new { isbn = m.Isbn, title = m.Title, favouritedBy = m.Users.Select(u => u.Username) }); var json = new JavaScriptSerializer().Serialize(topTenFavoriteTeenMovies); File.WriteAllText(@"top-10-favourite-movies.json", json); }
static void Main(string[] args) { var context = new MovieContext(); var ratedMoviesByUser = context.Users .Where(u => u.Username == "jmeyery") .Select(u => new { username = u.Username, ratedMovies = u.Ratings.Where(r => r.UserId == u.Id) .Select(r => new { title = r.Movie.Title, userRating = r.Stars, averageRating = r.Movie.Ratings.Select(mr => mr.Stars).Average() }) .OrderBy(m => m.title) }); var json = new JavaScriptSerializer().Serialize(ratedMoviesByUser); File.WriteAllText(@"rated-movies-by-jmeyery.json", json); }