title: Converting a SQL subqueries to Linq query
body: <p>I am trying to convert this sql into Linq query but I am getting no success. Could you help with the same. </p>
  
  <pre><code>SELECT  G.Id,G.UserGroupName, G.Status, G.IsDeleted ,(SELECT COUNT(*) FROM UserGroupMapping U WHERE U.UserGroupId=G.Id) [UserCount]   
  ,(SELECT COUNT(*) FROM UserGroupRoleMapping R WHERE R.UserGroupId=G.Id) [RolesCount]  
  FROM UserGroup G
  </code></pre>