Aggregate function Count() using dynamic linq query

Question

I am trying to use Aggregate function Count() on some column using dynamic linq query but I am not able to achieve, what I am exactly looking is

Select Count(Id),Id 
from Table1 
Group By Id 
Having Count(Id) > 1

I want to convert the same query to dynamic linq query, any suggestions on how to achieve this?

use let keyword with having value Count(ID) and then construct linq query — Vishal Sharma, Sep 25 '13 at 11:48
Finally I was able to solve. got solution from the post http://stackoverflow.com/questions/2531679/how-to-write-this-linq-sql-as-a-dynamic-query-using-strings — Abhinay, Sep 25 '13 at 12:18
You might want to post what your solution was here and mark it as the selected answer for anyone else searching to do the same thing. — Ocelot20, Sep 25 '13 at 13:29

score 0 · Answer 1 · edited May 23 '17 at 12:05

0

Stolen from here:

var distinctItems = 
    from list in itemsList
    group list by list.ItemCode into grouped
    where grouped.Count() > 1
    select grouped;

edited May 23 '17 at 12:05

Community

1
1

answered Sep 25 '13 at 11:52

python_kaa

1,034
13
27

score 0 · Answer 2 · answered Sep 25 '13 at 12:09

The following two queries will give you the exact same result: first with lambda second result without.

        var Table1 = new List<Row>();

        for (int i = 0; i < 10; i++)
        {
            for (int m = 0; m < 5; m++)
            {
                for (int x = 0; x < i + m; x++)
                {
                    Table1.Add(new Row() { Id = m });
                }
            }
        }

        var result = Table1.GroupBy(row => row.Id)
                    .Where(p => p.Count() > 1);

        var resultB = from row in Table1
                      group row by row.Id into rowGrouped
                      where rowGrouped.Count() > 1
                      select rowGrouped;

        foreach (var r in resultB)
        {
            Console.WriteLine("ID {0} count: {1}", r.Key, r.Count());
        }

score -1 · Answer 3 · answered Sep 25 '13 at 11:48

-1

May be something like this

list.GroupBy(item => item.Id)
    .Where(group => group.Count() > 1)
    .Select(group => new {
                         Id = group.Key, 
                         Count = group.Count() });

answered Sep 25 '13 at 11:48

Mehmet Ataş

11,081
6
51
78

1

I want solution using DynamicLinq query.. what ever you suggested was using regular Linq query. – Abhinay Sep 25 '13 at 11:51

Aggregate function Count() using dynamic linq query

3 Answers3