Chapter 15, Try-It-Out pg570-573

supdike · June 14th, 2012, 02:07 PM

Hello,
Should this Try-It-Out list all of the reviews? My code runs without errors, but i only get 18 of the total 24 reviews listed on the reviews by genre page.
thanks!

Imar · June 14th, 2012, 03:39 PM

Hi there,

If you followed the exercises, it should only list the authorized reviews because of the Where clause in the query:

Code:

 
var allReviews = from review in myEntities.Reviews
      where review.Authorized == true
      orderby review.CreateDateTime descending
      select review;
Repeater1.DataSource = allReviews;
Repeater1.DataBind();

Maybe the missing reviews are not authorized? You can check in the Management section.

Cheers,

Imar

supdike · June 14th, 2012, 03:58 PM

That was it. thanks again.