public List<FilmDTO> rechercheFilm(string table, string criteria)
        {
            List<Film> listFilm =null;
            List<FilmDTO> listDTO = new List<FilmDTO>();
            switch (table)
            {
                case "Film":
                    listFilm = (from fi in instanceDC.Films
                                where fi.title.Contains(criteria) || fi.original_title.Contains(criteria)
                                select fi).ToList();
                    break;
                case "Acteur":
                    listFilm = (from ac in instanceDC.Actors
                               join fiac in instanceDC.FilmActors on ac.id equals fiac.id_actor
                               join fi in instanceDC.Films on fiac.id_film equals fi.id
                               where ac.name.Contains(criteria)
                               select fi).ToList();

                    break;
                case "Genre":
                    listFilm = (from ac in instanceDC.Genres
                                join fiac in instanceDC.FilmGenres on ac.id equals fiac.id_genre
                                join fi in instanceDC.Films on fiac.id_film equals fi.id
                                where ac.name.Contains(criteria)

                                select fi).ToList();

                    break;
                case "Réalisateur":
                    listFilm = (from ac in instanceDC.Realisateurs
                                join fiac in instanceDC.FilmRealisateurs on ac.id equals fiac.id_realisateur
                                join fi in instanceDC.Films on fiac.id_film equals fi.id
                                where ac.name.Contains(criteria)
                                select fi).ToList();
                    break;
            }

            foreach (Film item in listFilm)
                listDTO.Add(toFilmDTO(item));

            return listDTO;

        }