MovieDbContext db = new MovieDbContext();

            var start = Tools.WriteTimeStamp("starting /sql");
            //I can't do what I wanted so I'll build most of the MwGVM and then fill it with genre
            // strings right after
            Tools.TraceLine("Create strings group");
            var movieID_genreString_grouping = from mtg in db.MovieToGenres
                                 join genre in db.Genres on mtg.genre_ID equals
                                     genre.genre_ID
                                 group genre.genre_string by mtg.movie_ID;
            var grouping_array = movieID_genreString_grouping.ToArray();


            //create the list of partial mwgvms
            Tools.TraceLine("create partial mwgarry");
            var partial_Mwg_qry =
                //left outer join so that all movies get selected even if there's no omdb match
                from movie in db.Movies
                join omdb in db.Omdb on
                movie.movie_ID equals omdb.movie_ID into ps
                from p in ps.DefaultIfEmpty()

                //match the boxarts
                from boxart in db.BoxArts
                where movie.movie_ID == boxart.movie_ID

                //match the genres
                from grp in movieID_genreString_grouping
                where grp.Key == movie.movie_ID

                //create the NITVM
                select new NfImdbRtViewModel
                           {

                               Movie = movie,
                               Boxarts = boxart,
                               Genres = grp,
                               OmdbEntry = p

                           };

            //array instead list for performance
            var partial_NITVM_array = partial_Mwg_qry.ToArray();