Chapter 14

southside123 · March 28th, 2014, 04:29 PM

To get the 10 most recent reviews from the system, your query needs two important LINQ constructs:
first, it needs an Order By (orderby in C#) clause to order the list in descending order. It
then needs the Take method to take the first 10 reviews from that result set:

Code:

using (PlanetWroxEntities myEntities = new PlanetWroxEntities())
{
var recentReviews = (from myReview in myEntities.Reviews
orderby myReview.CreateDateTime descending
select new { myReview.Title, myReview.Genre.Name }).Take(10);
GridView1.DataSource = recentReviews;
GridView1.DataBind();
}

What's the markup for this exercise. I'm using a repeater but I cannot get it to work to take the first 10 reviews?

Imar · March 31st, 2014, 06:59 AM

The exercise uses a GridView, so all you need is an <asp:GridView runat="sever" ID="GridView1" /> on your page.

For a Repeater, you can use something like this (written in this forum editor and thus untested):

Quote:

<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<asp:Literal text='<%# Eval("Title")' runat="server" /> in genre:
<asp:Literal text='<%# Eval("Name")' runat="server" />
</ItemTemplate>
</asp:Repeater>

Hope this helps,

Imar

southside123 · March 31st, 2014, 01:12 PM

Hi Imar,

Thanks. The problem is resolved.