/SQL/Transalations from sql to Linq count and group by

Transalations from sql to Linq count and group by

var query = from s in Stock 
            group s by new {s.Id, s.SupId, s.Text, s.ExternalId} into g
            select new {g.Key.Id, g.Key.SupId, g.Key.Text, g.Key.ExternalId, Count = g.Count()};

Source: stackoverflow.com

Similar codes

2 votes281 views1 answer
Get first 3 letters name in sql
SQL
0 vote306 views1 answer
Oracle select partition
SQL
0 vote266 views2 answers
Avg() sql
SQL
16 votes328 views5 answers
Select last row in sql
SQL
0 vote287 views1 answer
Mysql_union
SQL
5 votes290 views1 answer
How to check nls format in oracle
SQL
25 votes308 views5 answers
Date in mysql
SQL
4 votes379 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote290 views1 answer
Oracle list proxy users
SQL
0 vote313 views1 answer
Sql commands in android
SQL