/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 vote251 views1 answer
Sql query to check if column contains alphabets
SQL
-2 votes260 views1 answer
Mysql see users and passwords
SQL
10 votes272 views6 answers
Mysql delete duplicates
SQL
14 votes276 views3 answers
Alter foreign key
SQL
0 vote248 views1 answer
Oracle query to see what scema i am working in
SQL
1 vote277 views1 answer
How to subtract from the value of a table in sql
SQL
2 votes276 views1 answer
Mariadb json select
SQL
0 vote277 views2 answers
Raise notice in postgresql function
SQL
0 vote286 views1 answer
Sql multiple into
SQL
1 vote276 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL