private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            String value = listBox1.GetItemText(listBox1.SelectedItem);

            var movies = from movieName in database.Movies
                         where movieName.title == value
                         select movieName;

            Movy movie = movies.First();

            moviesLabel.Text = "Title: " + movie.title + "\n" + "Release Year: " + movie.releaseYear + "\n" + "Language: " + movie.language + "\n";

            var genresID = from genreId in database.MovieGenres
                           where genreId.movieId == movie.movieId
                           select genreId;

            moviesLabel.Text += "Genre: ";
            foreach (var g in genresID)
            {
                var genres = from genre in database.Genres
                             where genre.genreId == g.genreId
                             select genre;

                Genre gg = genres.First();
                moviesLabel.Text += gg.description + ",";
            }
            moviesLabel.Text += "\n";

            var directorID = from id in database.Persons
                             where id.personId == movie.director
                             select id;

            moviesLabel.Text += "Director: " + directorID.First().name + "\n";

            var personNames = from p in database.Persons
                              from pr in database.PersonRoles
                              from pf in database.MoviePersons
                              where pr.personRolesId == pf.personRolesId &&
                              pf.movieId == movie.movieId &&
                              p.personId == pr.personId
                              select p.name;

            moviesLabel.Text += "Actor/Actresses: ";

            foreach (var name in personNames)
            {
                moviesLabel.Text += name.Trim() + ", ";
            }
        }
 partial void DeleteMovy(Movy instance);
 partial void InsertMovy(Movy instance);
 partial void UpdateMovy(Movy instance);
 private void detach_Movies(Movy entity)
 {
     this.SendPropertyChanging();
     entity.PersonRole = null;
 }