static void Main(string[] args) { using (var instance = new MovieDatabaseEntities()) { // Clear table instance.Database.ExecuteSqlCommand("DELETE FROM movies"); // Create new movie Movies movie = new Movies(); movie.Name = "Kill Bill: Vol. 1"; movie.Director = "Quentin Tarantino"; movie.Playtime = 111; // Add movie to database table instance.Movies.Add(movie); // Add more movies instance.Movies.Add(new Movies("Pulp Fiction", "Quentin Tarantino", 1540)); instance.Movies.Add(new Movies("Reservoir Dogs", "Quentin Tarantino", 99)); instance.Movies.Add(new Movies("Wall-E", "Andrew Stanton", 98)); instance.Movies.Add(new Movies("Drive ", "Nicolas Winding Refn", 100)); // Save movies instance.SaveChanges(); // Get a movie Movies wantedMovie = instance.Movies.SingleOrDefault(item => item.Name == "Pulp Fiction"); wantedMovie.Playtime = 154; // Save changed movie instance.SaveChanges(); // Show changed movie Console.WriteLine(string.Format("Filmname: {0}, Regisseur: {1}, Spielzeit: {2} min", wantedMovie.Name, wantedMovie.Director, wantedMovie.Playtime.ToString())); // Get all movies List <Movies> allMovies = instance.Movies.ToList(); // Show all movies foreach (Movies showMovie in allMovies) { Console.WriteLine(string.Format("Filmname: {0}, Regisseur: {1}, Spielzeit: {2} min", showMovie.Name, showMovie.Director, showMovie.Playtime.ToString())); } // Wait for input Console.ReadLine(); } }
static void Main(string[] args) { using (var instance = new MovieDatabaseEntities()) { // Clear table instance.Database.ExecuteSqlCommand("DELETE FROM movies"); // Create new movie Movies movie = new Movies(); movie.Name = "Kill Bill: Vol. 1"; movie.Director = "Quentin Tarantino"; movie.Playtime = 111; // Add movie to database table instance.Movies.Add(movie); // Add more movies instance.Movies.Add(new Movies("Pulp Fiction", "Quentin Tarantino", 1540)); instance.Movies.Add(new Movies("Reservoir Dogs", "Quentin Tarantino", 99)); instance.Movies.Add(new Movies("Wall-E", "Andrew Stanton", 98)); instance.Movies.Add(new Movies("Drive ", "Nicolas Winding Refn", 100)); // Save movies instance.SaveChanges(); // Get a movie Movies wantedMovie = instance.Movies.SingleOrDefault(item => item.Name == "Pulp Fiction"); wantedMovie.Playtime = 154; // Save changed movie instance.SaveChanges(); // Show changed movie Console.WriteLine(string.Format("Filmname: {0}, Regisseur: {1}, Spielzeit: {2} min", wantedMovie.Name, wantedMovie.Director, wantedMovie.Playtime.ToString())); // Get all movies List<Movies> allMovies = instance.Movies.ToList(); // Show all movies foreach (Movies showMovie in allMovies) { Console.WriteLine(string.Format("Filmname: {0}, Regisseur: {1}, Spielzeit: {2} min", showMovie.Name, showMovie.Director, showMovie.Playtime.ToString())); } // Wait for input Console.ReadLine(); } }