asp.net core ef count rows containing a specific data

Marius Vasile

5y2.8k.NET

I am trying to get data for a chart using

var getData = await _context.WOMains.Where(s => s.OrgID == orgid).Select(s => s.WOType).ToListAsync();
foreach (var item in getData)
{
WOMainChart = getData.Select(a => new WOChart
{
ChartData = item,
ChartValue = item.Count()
}).ToList();
}

In the table I have three disting WOType, each added only one time, so 3 rows in total. However, when I run the query I get 22 as a count for each. What am I doing wrong?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
Accepted answer
Hi Marius,

You need to do group by count for your type, Please refer below one
https://stackoverflow.com/questions/11564311/sql-to-entity-framework-count-group-by
+1
Marius Vasile5y ago
Thank you Kiran, DistinctBy is not present, I only have Distinct. Jignesh solution is perfect
+2
Marius Vasile5y ago
Thank you, it is working fine. I found that answer with my friend google but I was confused by
ChartData = s.Key,
ChartValue = s.Count()
because I was not finding my WOType
+2
Kiran Mohanty5y ago
Hi,
Mostly you are getting duplicate records . Please try as below
var getData = await _context.WOMains.Where(s => s.OrgID == orgid).Distinct(s => s.WOType).ToListAsync();
+1