title: Having trouble grabbing values from groupby
body: <p>So I am trying to grab two values from 2 different collections, the user collection which holds the names i need and the Post collection which holds the scores needed. I am trying to create a LINQ query that grabs all the post a user has posted, by comparing ID's, and then getting the lowest post score from that user. Here is what I have so far:</p>
  
  <p>This prints what the 2 values I need but wont group them by Min value. </p>
  
  <pre><code> var lowestQuery =
                  from user in Assignment1.userDict
                  from post in Assignment1.allPosts
                  where user.Value.ID == post.AuthorID
                  orderby user.Value.Name ascending
                  group post.Score by new { user.Value.Name, post.Score } into scores
                  select new
                  {
                      name = scores.Key,
                      lowestScore = scores.Min()
                  };
  </code></pre>
  
  <p>Basically just need the users lowest post but I am having trouble doing that with grouping two values. When I just group by user.value.Name I am able to get the list of names correctly but not the Score since it doesnt exist in scores that i created with the groupby statement. Any help would be appreciated</p>