Working with Queries and Anonymous Types

guynorton · October 9th, 2010, 07:20 PM

In BegAsp 3.5 The 'Genre - Review' TryOut query offers up a collection of reviews for each genre. Can you access sub-collections of collections?

For example: Genre > Review (collection) > UserComment (collection)?

Attempts on my own similarly structured data have failed.

Regards, Guy

-------

var allGenres = from genre in myDataContext.Genres
orderby genre.Name
select new { genre.Name, genre.Reviews };

Imar · October 10th, 2010, 03:12 AM

Hi there,

You don't need to query them separately; each Review already contains a reference to its associated UserComments. The following should work and displays all comments for all reviews:

Code:

var allGenres = from genre in myDataContext.Genres
                orderby genre.Name
                select new { genre.Name, genre.Reviews };
 
foreach (var genre in allGenres)
{
  foreach (var review in genre.Reviews)
  {
    foreach (var userComment in review.UserComments)
    {
      string comment = userComment.Comment;
    }
  }
}

Hope this helps,

Imar