public void IncreaseTitleOfMoviesWhichWasRentedMoreThanTwiceBy1()
{
using (var db = new CodeFirstContext())
{
var movies = (from copy in db.Copies
join rental in db.Rentals on copy.CopyId equals rental.CopyId
join movie in db.Movies on copy.MovieId equals movie.MovieId
group copy by movie.MovieId into g
select new
{
MovieId = g.Key,
Count = g.Count()
});
foreach (var movie in db.Movies)
{
if (movies.Any(m => m.MovieId == movie.MovieId))
{
movie.Price = movie.Price + 1f;
}
}
db.SaveChanges();
foreach (var row in db.Movies)
{
Console.WriteLine(row.ToString());
}
}
}
public void DeleteAllMoviesInWhichNoActorsPlayed()
{
using (var db = new CodeFirstContext())
{
var moviestoDelete = db.Movies.Where(k => db.Starring.Any(m => m.MovieId != k.MovieId));
db.SaveChanges();
foreach (var row in db.Movies)
{
Console.WriteLine(row.ToString());
}
}
}
public void SetNewPriceForTaxiDriver()
{
using (var db = new CodeFirstContext())
{
var movie = db.Movies.Where(m => m.Title == "Taxi Driver").FirstOrDefault();
movie.Price = 5;
db.SaveChanges();
foreach (var row in db.Movies)
{
Console.WriteLine(row.ToString());
}
}
}
public void RemoveMoviesProducedin2005()
{
using (var db = new CodeFirstContext())
{
var moviesToRemove = db.Movies.Where(m => m.Year == 2005);
db.Movies.RemoveRange(moviesToRemove);
db.SaveChanges();
foreach (var row in db.Movies)
{
Console.WriteLine(row.ToString());
}
}
}
public void InsertIntoMoviesTheIncredibels()
{
using (var db = new CodeFirstContext())
{
db.Movies.Add(new Movie {
MovieId = 12, Title = "The Incredibles", Year = 2004, AgeRestriction = 0, Price = 9.5f
});
db.SaveChanges();
foreach (var row in db.Movies)
{
Console.WriteLine(row.ToString());
}
}
}
public void InsertNewCopyOfPlatoon()
{
using (var db = new CodeFirstContext())
{
db.Copies.Add(new Copy {
CopyId = db.Copies.Select(c => c.CopyId).Max() + 1, Available = true, MovieId = db.Movies.Where(m => m.Title == "Platoon").Select(m => m.MovieId).FirstOrDefault()
});
db.SaveChanges();
foreach (var row in db.Movies)
{
Console.WriteLine(row.ToString());
}
}
}
public void InsertIntoMoviesMadagascar()
{
using (var db = new CodeFirstContext())
{
db.Movies.Add(new Movie {
MovieId = 11, Title = "Madagascar", Year = 2005, AgeRestriction = 0, Price = 10.5f
});
db.SaveChanges();
foreach (var row in db.Movies)
{
Console.WriteLine(row.ToString());
}
}
}
public void IncreasePriceOfAllMoviesProducedBefore1980By05()
{
using (var db = new CodeFirstContext())
{
foreach (var movie in db.Movies.Where(m => m.Year < 1980))
{
movie.Price = movie.Price + 0.5f;
}
db.SaveChanges();
foreach (var row in db.Movies)
{
Console.WriteLine(row.ToString());
}
}
}