static void Main(string[] args)
{
var context = new MoviesContext();
Console.WriteLine(context.Countries.Count());
}
static void Main(string[] args)
{
var context = new MoviesContext();
var adultsMovies = context.Movies
.Where(m => m.AgeRestriction == AgeRestriction.Adult)
.Select(m => new
{
title = m.Title,
ratingsGiven = m.Ratings.Count
}).OrderBy(m=>m.title).ThenBy(m=>m.ratingsGiven);
var json = new JavaScriptSerializer().Serialize(adultsMovies);
Console.WriteLine(json);
System.IO.File.WriteAllText(@"../../adult-movies.json", json);
}
static void Main(string[] args)
{
var db =new MoviesContext();
var topFavMovies = db.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 json = new JavaScriptSerializer().Serialize(topFavMovies);
Console.WriteLine(json);
System.IO.File.WriteAllText(@"../../top-10-favourite-movies.json", json);
}