/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

0 vote188 views1 answer
Sqlite update where exists
SQL
0 vote157 views1 answer
Sql select column name like from multiple tables
SQL
9 votes140 views2 answers
Cmd to rename a collumn name in sql
SQL
3 votes152 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote164 views1 answer
Sqlite update from another table
SQL
0 vote143 views1 answer
MySQL INSERT IGNORE Statement
SQL
-1 vote138 views1 answer
Round up and down sql
SQL
0 vote143 views1 answer
Default column value in sql same as other column
SQL
5 votes164 views1 answer
How to check port number for postgresql
SQL
0 vote137 views1 answer
Mysql earlier than date
SQL