title: convert sql query to LINQ statement
body: <p>I am struggling to translate this sql statement to a LINQ statement.</p>
  
  <pre><code>select r.FirstName + ' ' + r.Surname as [Name], count(*) as  [Number of Submissions]
  from Researcher r
  join ResearcherSubmission rs on r.ResearcherID = rs.ResearcherID
  join Submission s on s.SubmissionID = rs.SubmissionID
  group by r.FirstName, r.Surname
  </code></pre>
  
  <p>this is what I got so far, but I could be completely wrong as I am very new to writing LINQ statements</p>
  
  <pre><code>from r in Researcher
  join rs in ResearcherSubmission on rs.ID equal s in Submission
  count s in submission
  group by r FirstName + ' ' + Surname
  </code></pre>
  
  <p>the SQL query does give me results I'm looking for.</p>