/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 votes234 views2 answers
How to DROP a table in mysql
SQL
-1 vote162 views1 answer
What is in operator
SQL
0 vote299 views1 answer
Sqlite display data in separated columns
SQL
0 vote154 views1 answer
Sql find leading space
SQL
0 vote227 views1 answer
Sql to search who modified
SQL
10 votes169 views2 answers
What is database
SQL
0 vote241 views1 answer
ORA-00942
SQL
0 vote150 views1 answer
Mysql case when on date
SQL
5 votes156 views1 answer
How to check nls format in oracle
SQL
0 vote167 views2 answers
Port 5432 is already in use mac
SQL