title: Convert SQL code to LINQ - Group By and Sum
body: <p>can not convert to this code to LINQ and preview to data grid view.</p>
  
  <p>I have looked at <a href="https://stackoverflow.com/questions/26742720/how-to-convert-this-query-to-linq">this</a> answer but it is not helping me </p>
  
  <pre><code>select tbl_user.id,tbl_user.name,tbl_user.family, sum(tbl_price.price) 
          from tbl_user,tbl_price
          where tbl_user.id=tbl_price.user_id_fk
          group by tbl_user.name+''+tbl_user.family,tbl_user.id,tbl_user.name,tbl_user.family
  </code></pre>
  
  <p>please help me to convert this code to linq</p>