static void Main(string[] args)
{
using (var db = new MovieContext())
{
// Useful tactic ONLY in development.
// At start of your program, always delete the database and then re-create it
// This ensures a fresh database everytime you run your program.
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
}
// Adding a studio: "20th Century Fox" with 4 movies
using (var db = new MovieContext())
{
Studio studio = new Studio
{
Name = "20th Century Fox",
Movies = new List <Movie>
{
new Movie {
Title = "Avatar", Genre = "Action"
},
new Movie {
Title = "Deadpool", Genre = "Action"
},
new Movie {
Title = "Apollo 13", Genre = "Drama"
},
new Movie {
Title = "The Martian", Genre = "Sci-Fi"
}
}
};
// Adding a studio: "Universal Pictures" with no movies
Studio studio2 = new Studio
{
Name = "Universal Pictures"
};
db.Add(studio);
db.Add(studio2);
db.SaveChanges();
}
// Adding a movie: "Jurassic Park" to the Universal Pictures Studio
using (var db = new MovieContext())
{
Movie movie = new Movie
{
Title = "Jurassic Park", Genre = "Action"
};
Studio studioToUpdate = db.Studios.Include(s => s.Movies).Where(s => s.StudioId == 2).First();
studioToUpdate.Movies.Add(movie);
db.SaveChanges();
}
// Moving Apollo 13 from the 20th Century Fox studio to the Universal Pictures studio
using (var db = new MovieContext())
{
Movie movie = db.Movies.Where(m => m.Title == "Apollo 13").First();
movie.Studio = db.Studios.Where(s => s.Name == "Universal Pictures").First();
db.SaveChanges();
}
using (var db = new MovieContext())
{
Movie movieToDelete = db.Movies.Where(m => m.MovieID == 2).First();
db.Remove(movieToDelete);
db.SaveChanges();
}
using (var db = new MovieContext())
{
var studios = db.Studios.Include(s => s.Movies);
foreach (var s in studios)
{
Console.WriteLine(s);
foreach (var m in s.Movies)
{
Console.WriteLine("\t" + m);
}
Console.WriteLine();
}
}
}
static void Main(string[] args)
{
using (var db = new StudioContext())
{
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
}
using (var db = new StudioContext())
{
Studio Studio = new Studio
{
Name = "20th Century Fox",
Movies = new List <Movie> {
new Movie {
Title = "Avatar", Genre = "Action"
},
new Movie {
Title = "Deadpool", Genre = "Action"
},
new Movie {
Title = "Apollo 13", Genre = "Drama"
},
new Movie {
Title = "The Martians", Genre = "Sci-Fi"
},
}
};
Studio Studio2 = new Studio
{
Name = "Universal Pictures"
};
db.Add(Studio);
db.Add(Studio2);
db.SaveChanges();
}
using (var db = new StudioContext())
{
Movie Movie = new Movie {
Title = "Jurrasic Park", Genre = "Action"
};
Movie.Studio = db.Studios.Where(s => s.Name == "Universal Pictures").First();
db.Add(Movie);
db.SaveChanges();
}
using (var db = new StudioContext())
{
Movie Movie = db.Movies.Where(m => m.Title == "Apollo 13").First();
Movie.Studio = db.Studios.Where(s => s.Name == "Universal Pictures").First();
db.SaveChanges();
}
using (var db = new StudioContext())
{
Movie Movie = db.Movies.Where(m => m.Title == "Deadpool").First();
db.Remove(Movie);
db.SaveChanges();
}
using (var db = new StudioContext())
{
var studios = db.Studios.Include(s => s.Movies);
foreach (var s in studios)
{
Console.WriteLine(s);
foreach (var p in s.Movies)
{
Console.WriteLine("\t" + p);
}
}
}
}
