/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 vote327 views4 answers
Best data type to represent money in mysql
SQL
13 votes311 views4 answers
Mysql get last row
SQL
0 vote329 views3 answers
Insert or ignore postgres
SQL
20 votes389 views4 answers
Sql count if
SQL
0 vote334 views1 answer
Raven ql select count
SQL
0 vote335 views1 answer
How to select an index in oracle sql
SQL
8 votes320 views1 answer
Oracle add month
SQL
0 vote336 views1 answer
Oracle DROP PROGRAM
SQL
0 vote315 views1 answer
Back up stored procedures mysql
SQL
3 votes314 views1 answer
Oracle apex message quit website
SQL