static void Main() { var context = new MoviesContext(); var moviesCount = context.Movies.Count(); Console.WriteLine(moviesCount); }
static void Main() { var context = new MoviesContext(); // 1. Adult Movies var adultMovies = context.Movies .Where(m => m.AgeRestriction == AgeRestriction.Adult) .OrderBy(m => m.Title) .ThenBy(m => m.Ratings.Count) .Select(m => new { title = m.Title, ratingsGiven = m.Ratings.Count }); var json = JsonConvert.SerializeObject(adultMovies, Formatting.Indented); File.WriteAllText("../../adult-movies.json", json); //2. Rated Movies by User var jmeyeryMovies = context.Movies.SqlQuery( "SELECT m.Title [title], r.Stars [userRating], (SELECT ROUND(AVG(CAST(Stars AS FLOAT)), 2) FROM Ratings rr INNER JOIN Movies mm ON mm.Id = rr.MovieId WHERE m.Title = mm.Title) [averageRating] FROM Movies m INNER JOIN Ratings r ON r.MovieId = m.Id Where r.UserId = (SELECT Id From Users Where Username = '******') GROUP BY r.Stars, m.Title"); // JSON output in rated-movies-by-jmeyery.json //3. Top 10 Favourite Movies var favouriteTeenMovies = 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) }).Take(10); var json3 = JsonConvert.SerializeObject(favouriteTeenMovies, Formatting.Indented); File.WriteAllText("../../top-10-favourite-movies.json", json3); }