title: LINQ to SQL Group by C# problem
body: <p>I recently started to use LINQ to SQL and i have a minor complex query i need help with.
  I've got a table in my database called MovieComment, with the following columns:</p>
  
  <ul>
  <li>CommentID</li>
  <li>UserID</li>
  <li>MovieID</li>
  <li>Comment</li>
  <li>Timestamp</li>
  </ul>
  
  <p>So, what i wanna do is to group the comments on MovieID and save them into my object called Movie, where the MovieID is being saved in the MovieID post, and the Linq object is saved inside the ObservableCollection inside the Movie object.</p>
  
  <pre><code>public class Movie
  {
      #region Member Variables
  
      public int MovieID { get; set; }
      public string Title { get; set; }
      public string Content { get; set; }
      public Uri Poster { get; set; }
      public double Rating { get; set; }
      public DateTime Timestamp { get; set; }
  
      public ObservableCollection&lt;MovieComment&gt; Comments { get; set; } // Linq object: MovieComment
  
      #endregion // Member Variables
  }
  </code></pre>
  
  <p>I've come up with the following linq query where i get the MovieID, but i dont really know how i should proceed to get a hold of all the other data</p>
  
  <pre><code>public ObservableCollection&lt;Movie&gt; LoadMovieID(int _userID, int _limit)
  {
      ObservableCollection&lt;Movie&gt; movies = new ObservableCollection&lt;Movie&gt;();
  
      var query = (from mc in db.MovieComment
              where mc.UserID == _userID
              orderby mc.Timestamp descending
              group mc by mc.MovieID into movie
              select new
              {
                  MovieID = movie.Key,
              }).Take(_limit);
  
      foreach (var row in query)
      {
          Movie movie = new Movie();
          movie.MovieID = row.MovieID;
  
          // I want to get the following:
          // movie.MovieComment = MovieComment-objects with the MovieID == row.MovieID
  
          movies.Add(movie);
      }
  
      return movies;
  }
  </code></pre>
  
  <p>Is this even possible in a single query? Thankful for all the help i can get</p>