T-SQL "with" Entity Framework Equivalent

entity-framework linq linq-to-entities

Question

How can I write a linq to entities query that includes a having clause?

For example:

SELECT State.Name, Count(*) FROM State
INNER JOIN StateOwner ON State.StateID = StateOwner.StateID
GROUP BY State.StateID
HAVING Count(*) > 1
1
15
9/10/2009 6:35:22 PM

Accepted Answer

Any reason not to just use a where clause on the result?

var query = from state in states
            join stateowner in stateowners
              on state.stateid equals stateowner.stateid
            group state.Name by state.stateid into grouped
            where grouped.Count() > 1
            select new { Name = grouped.Key, grouped.Count() };
28
9/10/2009 6:39:01 PM

Popular Answer

I believe you can use a GroupBy followed by a Where clause and it will translate it as a Having. Not entirely sure though.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow