Write sql statement using linq

Question

How can I write the following sql code in LINQ

select count(1) Cnt,state 
from yourtable
group by state
order by Cnt desc Limit 5

I am trying somthing like this

(from topPro in CS.state group topPro by new {
       Name = topPro.state.Name
} into g
select new{
     StateName = g.Key.Name,
     Count = g.Count(x=>x.state)
}

Stackoverflow is not a SQL-LINQ conversion tool. Show what you have tried. — Tim Schmelter
– Tim Schmelter, Commented Feb 18, 2015 at 10:17
How far have you got so far? Do you have LINQ working with your database at all? Is it using EF? What have you tried for your query? What went wrong? Please read tinyurl.com/stack-hints — Jon Skeet
– Jon Skeet, Commented Feb 18, 2015 at 10:17
@user2998990: use Count = g.Count() instead of Count = g.Count(x=>x.state) — Tim Schmelter
– Tim Schmelter, Commented Feb 18, 2015 at 10:27

user2998990 · Accepted Answer · 2015-02-18 10:28:21Z

1

I got the answer

var top5Pros = (from topPro in CS.state
group topPro by new { Name = topPro.state.Name } into g
select new
{
StateName = g.Key.Name,
Count = g.Count()
}).OrderByDescending(w => w.Count).Take(5);

answered Feb 18, 2015 at 10:28

user2998990

9805 gold badges20 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Write sql statement using linq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related