LINQ

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

Hi Imar,

First, thank you for answering all my questions.

I'm having a problem displaying a single review from the Review table.

I'm trying like this:

Code:

using (PlanetWroxEntities myEntities = new PlanetWroxEntities())
        {
            var review37 = (from r in myEntities.Reviews
                                  where r.Id == 37
                                  select r).Single();
        }

but it's not working. It's showing this error on the browser:

Exception Details: System.ArgumentException: An invalid data source is being used for Repeater2. A valid data source must implement either IListSource or IEnumerable.

Imar · March 31st, 2014, 05:54 PM

Hi there,

You can't use a list control with a single instance returned from a query. So either drop the Single() statement (so you still get a collection, but with only one object in it) or use the a different control such as a Label (or multiple labels) to display the object. The AddEditReviewHandCoded page shows how that works.

Hope this helps,

Imar