/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 vote206 views1 answer
Testing sql queries
SQL
0 vote175 views1 answer
Char vs varchar2 in sql
SQL
0 vote188 views1 answer
Hour and minute between two datatime sql
SQL
0 vote165 views1 answer
Oracle DROP PROGRAM
SQL
10 votes177 views1 answer
Dba_dependencies
SQL
0 vote173 views1 answer
How to fix mysql stop unexpectedly
SQL
4 votes174 views1 answer
SQL order random
SQL
4 votes180 views1 answer
Mysql ip address
SQL
0 vote201 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote202 views2 answers
How to combine two sql queries in one result
SQL