protected void Application_Start()
{
Database.SetInitializer<MoviesContext>(new MigrateDatabaseToLatestVersion<MoviesContext, Configuration>());
using (var context = new MoviesContext())
{
context.Movies.ToList();
}
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
}
static void Main()
{
var context = new MoviesContext();
var user = 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(mr => mr.Stars)
})
});
string json = JsonConvert.SerializeObject(user, Formatting.Indented);
File.WriteAllText("../../rated-movies-by-jmeyery.json", json);
}