/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 vote117 views1 answer
Postgres get database encoding
SQL
5 votes113 views1 answer
Oracle nls parameters
SQL
4 votes120 views2 answers
Postgres update single column
SQL
4 votes120 views1 answer
Find tables with column name in sql
SQL
3 votes118 views1 answer
How to check schema privileges in oracle
SQL
2 votes103 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote74 views1 answer
How to see the content of tables in pgadmin
SQL
1 vote115 views1 answer
Alphabetical order mysql
SQL
0 vote118 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote119 views1 answer
Setting default value for Boolean data type in SQL
SQL