Lambda Expression Group by

Question

I have a problem with Group by in lambda expression, Lets say I have the following SQL query:

SELECT [name] FROM [db].[dbo].[table] GROUP BY [key]

I want to get the same result using lambda expression, I tried this :

IQueryable<table> query = context.table.GroupBy(s => s.key);

But I get "missing cast" error.

What I miss here?

related: [How to get values from IGrouping](https://stackoverflow.com/questions/8521025/how-to-get-values-from-igrouping), [Convert IEnumerable> to IEnumerable](https://stackoverflow.com/questions/24122927/convert-ienumerableigroupingt-k-to-ienumerablek?noredirect=1&lq=1) — Drag and Drop, Mar 07 '19 at 10:34
Possible duplicate of [How to get values from IGrouping](https://stackoverflow.com/questions/8521025/how-to-get-values-from-igrouping) — Drag and Drop, Mar 07 '19 at 10:36
The solution is to find the return type of GroupBy and goes from there in your research. Yes, IGrouping herits from IEnumerable — Drag and Drop, Mar 07 '19 at 10:41
Your select will fail? You are getting name but group by key? — Pablo notPicasso, Mar 07 '19 at 11:36

score 0 · Answer 1 · answered Mar 07 '19 at 12:09

0

Please try this.

IQueryable<table> query = context.table..AsQueryable().GroupBy(s => s.key)..SelectMany(x => x);

answered Mar 07 '19 at 12:09

Hemang A

1 Answers1