EntityFramework count members with condition C#

Question

I have a table called LiquidatorRepresentative. The table contains the Represented Member Id. I don't know how to count how many entries in LiquidatorRepresentative have the same RepresentedMemberId in C# using EntityFramework or LinQ

Thanks in advance.

EDIT: I already made a list InfoList and now the problem is checking if there are entries with Type=15 and same RepresentedMemberId. I can't use a store procedure because the program is already running slow because of linq.

You should post more information about your problem… But my tip: Use a stored procedure… this will be the fastest solution. See http://stackoverflow.com/a/20911004/1320170 for how to use stored procedures with EF. — musium, Feb 11 '16 at 10:40

score 2 · Accepted Answer · edited Feb 11 '16 at 10:50

2

Basically, what you need - is to group data by Represented Member Id and then count items in each group. Code will be similar to:

var groups = liquidatorRepresentative.GroupBy(lr => lr.RepresentedMemberId).Select(group => new { Id = group.Key, Count = group.Count() })

foreach (var group in groups)
{
    Console.WriteLine("{0} {1}", group.Id, group.Count);
}

edited Feb 11 '16 at 10:50

H H

263,252
30
330
514

answered Feb 11 '16 at 10:44

berliner

1,887
3
15
23

score 1 · Answer 2 · answered Feb 11 '16 at 13:59

If you want to count the number of entities that meet a condition, then you can simply count:

var count = await (from x in set
                   where condition(x)
                   select x).CountAsync();

This will be converted into a select count(1)... on the database: it will only return the count, not all the data.

score 0 · Answer 3 · answered Feb 11 '16 at 10:45

A Groupby extension method should do the trick

   var groupCount = db.LiquidatorRepresentative.GroupBy(info => info.RepresentedMemberId)
                            .Select(group => new { 
                                 RepresentedMemberId = group.Key, 
                                 Count = group.Count() 
                            });

score 0 · Answer 4 · answered Feb 12 '16 at 08:17

Thank you for your help guys. I made a list with the content i needed to check and instead of forEach, i brought the first entry in element. This code works for what i needed, thanks for help.

if(InfoList.Where(adx => adx.Id == element.Id && adx.Type == "15").Count() > 1
   || InfoList.Where(adx=adx.Id == element.Id && adx.Type == "16").Count() > 1)

EntityFramework count members with condition C#

4 Answers4