How to display only authorized reviews

jtcours · April 3rd, 2011, 08:39 PM

Currently, Reviews/Default.aspx and Reviews/AllByGenre.aspx as presented in the Try It Out sections (at least as of Chapter 18--I haven't quite finished the book yet) display all reviews, whether or not the Authorized bit is set. Is there a way to rearrage the LINQ query to exclude unauthorized reviews? This query, from Reviews/Default.aspx, is as close as I've been able to come, but the join flattens the hierarchical data, so the output contains duplicate Genre headings.

Code:

        var favGenres = from genre in myEntities.Genres
                        join review in myEntities.Reviews on genre.Id equals review.GenreId
                        where Profile.FavoriteGenres.Contains(genre.Id) 
                          && (genre.Reviews.Count() > 0) 
                          && (review.Authorized == true)
                        orderby genre.Name
                        select new { genre.Name, genre.Reviews };

If I remove the join, I get an error from the "review.Authorized == true" condition that the name "review" does not exist in the current context, which makes sense because it "review" is defined in the join. Substituting "myEntities.Reviews.Authorized == true" with the "join" removed also results in an error. Should I be using some sort of subquery here?

Thanks very much in advance,
Jeff

Imar · April 4th, 2011, 02:50 AM

Hi there,

You can add a Where clause to your select statement for the reviews. You can see a VB example here: Authorized reviews

Hope this helps, but if it doesn't, please let me know.

Cheers,

Imar

jtcours · April 5th, 2011, 01:06 AM

. . . and the student was enlightened. This:

Code:

select new { genre.Name, Reviews = genre.Reviews.Where (r => r.Authorized == true) };

did the trick. Thanks very much for the help!

Imar · April 5th, 2011, 03:03 AM

Yep, that's exactly what you need.....

Cheers,

Imar