/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 vote135 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote131 views1 answer
Get number of table colums in sql query
SQL
8 votes147 views1 answer
See all users mysql
SQL
0 vote127 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote127 views1 answer
Add colum date in sql
SQL
2 votes126 views1 answer
Ssh mysql port forwarding
SQL
22 votes135 views4 answers
Mysql reset auto increment id
SQL
0 vote132 views1 answer
How to order result of subquery in select
SQL
0 vote130 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote141 views3 answers
How to assign custom id in mysql
SQL