/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 vote201 views1 answer
How to install sql in anaconda
SQL
0 vote239 views1 answer
Create tables from xsd to sql server database c#
SQL
1 vote212 views1 answer
Query for all indexes in table postgres
SQL
0 vote204 views1 answer
Oracle drop type
SQL
0 vote259 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote202 views1 answer
Match end of string regex sql
SQL
1 vote200 views1 answer
Simple project for database
SQL
7 votes219 views1 answer
Oracle reset sequence
SQL
-1 vote201 views2 answers
Get day in sql
SQL
0 vote159 views1 answer
Psql not found windows
SQL