single review for every genre

sophia · October 21st, 2012, 03:51 PM

Hi Imar I want to show recently added (single) review for every genre on a page, and on clicking genre name I will show all reviews falling in that genre but I am having some problem.
I am not getting any way to show only single review with every genre.
How I can change this code so that it works...

Code:

using (PlanetWroxDataContext myDataContext = new PlanetWroxDataContext())
{
var allGenres = from genre in myDataContext.Genres
orderby genre.Name
select new { genre.Name, genre.Reviews };
Repeater1.DataSource = allGenres;
Repeater1.DataBind();
}

In design view I am using repeater and datalist controls.

Imar · October 21st, 2012, 06:56 PM

H there,

You need to call FIrst() on the Reviews collection with a reversed sort order. Take a look at page 436 for an example.

Cheers,

Imar

sophia · October 23rd, 2012, 04:17 AM

I looked at that query but It is just for reviews but not the Genre and Reviews Combined.

How I return latest review for every genre using repeater/datalist controls or by other means?
Thanks

Imar · October 24th, 2012, 06:46 PM

You can us the exact same concepts here. Just call First():

genres.Reviews.First()

However, that returns a single Review, not a collection so you need to change the control or code to display the review.

Cheers,

Imar