title: Query with join, group by and count to linq
body: <p>im doing this query on sql and it works, but how do i make it to Linq ?</p>
  <blockquote>
  <p>select b.Name,a.idempresa,count(1) as cuenta from Descarga_XML_recepcion_V2  as a
  inner join EnterpriseSGE as b on a.idempresa = b.EnterpriseSGEId group by idempresa,b.name</p>
  </blockquote>
  <p>this is what it should bring</p>
  <pre><code>name1 | 5041 |  583
  name2 | 4031 |  1730
  name3 | 5042 |  640
  name4 | 4034 |  300
  name5 | 6047 |  861
  name6 | 5043 |  187
  name7 | 4033 |  318
  </code></pre>