var min_qry = "select  top(1) * from Movies where year != \'\' order by year ASC ";
            var min_res = db.Movies.SqlQuery(min_qry);
            var min_list = min_res.ToList();

            var max_qry = "select  top(1) * from Movies order by year DESC ";
            var max_res = db.Movies.SqlQuery(max_qry);
            var max_list = max_res.ToList();