/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

1 vote373 views1 answer
Mariadb get column names from table
SQL
0 vote325 views2 answers
Starting mysql service from mac
SQL
2 votes309 views1 answer
Delete all value query
SQL
6 votes363 views2 answers
Subtr Oracle ?
SQL
0 vote318 views1 answer
Sql select with apostrohpe
SQL
6 votes320 views1 answer
What is where clause in sql
SQL
-1 vote356 views1 answer
Mysql faster insert
SQL
0 vote314 views1 answer
Why mysql is used?
SQL
0 vote343 views1 answer
Alter boolean column postgresql
SQL
0 vote319 views1 answer
Mysql could not fetch tables
SQL