/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

11 votes177 views3 answers
How to get last row of table in sql
SQL
1 vote184 views1 answer
Mysql month name extract
SQL
0 vote176 views1 answer
Check if string is a number sql
SQL
2 votes199 views1 answer
Python sql
SQL
0 vote278 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote201 views1 answer
Convert int to varchar sql
SQL
1 vote175 views1 answer
Spark sql concatenate string and int
SQL
0 vote218 views1 answer
Sql select without column name
SQL
0 vote211 views1 answer
Ms sql print more than 1 variable
SQL
1 vote171 views1 answer
Md5 encryption for existing records
SQL