title: How to convert this SQL statement to Linq for C#
body: <p>I am trying to convert my simple SQL statement into Linq format for my C# application but I always seem to struggle making the conversion. I downloaded linqpad and have been playing around with it but I'm still having issues with the proper format.</p>
  
  <p>My SQL statement:</p>
  
  <pre><code>SELECT distinct PictureCity, PictureState
  FROM Website_Gallery
  GROUP BY PictureCity, PictureState, PictureDate
  ORDER BY PictureCity, PictureState
  </code></pre>
  
  <p>The results are ordered by PictureCity and look like this:</p>
  
  <pre><code>Abington    MA
  Acton   MA
  Acushnet    MA
  Agawam  MA
  Andover MA
  Arlington   MA
  Arlington   TX
  Ashby   MA
  Ashland MA
  </code></pre>
  
  <p>What I have so far in my C# application which I can't seem to get to work. (I suck at linq).</p>
  
  <pre><code>var Results = _context.Website_Gallery
  .(g =&gt; g.PictureCity, g =&gt; g.PictureState).AsEnumerable()
  .Select g
  .GroupBy(g =&gt; g)
  </code></pre>