/// <summary> /// Get average move rating /// </summary> /// <param name="title">Movie title</param> /// <returns>Movie's average score</returns> public double GetMovieAverageRatings(string title) { using var dbContext = new MovieRatingDbContext(); return(dbContext.MovieScores .Where(x => x.Title == title) .Select(x => x.Score) .ToList() .DefaultIfEmpty(0) .Average()); }
/// <summary> /// Add new movie rating to db /// </summary> /// <param name="title">Movie title</param> /// <param name="score">Score</param> public void AddNewRating(string title, int score) { using var dbContext = new MovieRatingDbContext(); var movieRating = new MovieRatingDO() { Title = title, Score = score }; dbContext.MovieScores.Add(movieRating); dbContext.SaveChanges(); }